Devart Forums

You don't need to call the Next method in your loop. When you call the Delete method, the query moves to the next record automatically.

Do the following:
- uninstall IBDAC;
- search your computer for DBAccess.* and MemData.* and delete these files if they are found;
- install IBDAC again.

Which provider are you using? Some providers require setting the DMLRefresh property to True to get new values from the server.

InterBase returns all fields in UTF8 when the connection character set is UTF8.

Use the information from the metadata tables like RDB$FIELDS to get fields character set.

Use the Server property to set Oracle database name.

We will add the EnableLargeint option to the next build of PostgreSQL driver.

Yes, you are right.

Please provide us a script for creating the table.

You should enable OCI Unicode environment to use Unicode characters in SQL statements. Set the OCIUnicode global variable from the OraCall unit to True.

Use a SQL statement with WHERE condition:

SELECT * FROM MyTable
WHERE id = :id

Set the ID parameter to ID of a record that you want to edit. Then open or refresh the query. If you need to add a new record, you can set the parameter to Null.

TOraStoredProc opens the first cursor inside the component itself.

Use TOraSQL to prevent this. Copy the SQL statement from TOraStoredProc to TOraSQL and execute the procedure using TOraSQL.

You can use SERIAL data type. PostgreSQL automatically creates a sequence for such fields. Use the following statement to set the last value for a sequence:

Please see my reply to your e-mail.

We will add the EnableLargeint driver option to the next build.

The character set used in TStringField depends on Windows regional settings. So both TStringField and TWideStringField can contain non-English characters.

TWideStringField is used for any character set when UseUnicode=True because many character sets cannot be represented in TStringField (not only UTF8).