Forums

Hi guys, I have started playing with an external Database and can't work out how to create a new row.

I can modify a row using this code without a problem.
code : Tbl_PBSH_BLEcho_CodeTables;
dict : Tbl_PBSH_BLEcho_CodeTablesDict;
begin
create dict;
code := dict.getAtKey ('codeCode');
code.codeDescription := 'codeDescription';
code.codeShortName := 'codeShortName';
code.update;

But when trying to create a new row there is no create method
code : Tbl_PBSH_BLEcho_CodeTables;
dict : Tbl_PBSH_BLEcho_CodeTablesDict;
begin
create dict;
//create code transient; //"these don't work"
//create code;
code.code := 'codeCodeNew';
code.codeDescription := 'codeDescription';
code.codeShortName := 'codeShortName';
code.update;

Does anyone know how this should be coded?

Cheers, H

It's been a while since I last did this, but from memory you use the createObject method on the external dictionary to create a new row in the desired table.

For example, using your sample code the quasi-code would look something like the following. (Note: I don't have access to an external database to test this currently..)
Cheers,
BeeJay.

Thanks BeeJay, That works a treat, H