Hi All,
Currently using the following example code from the Knowledge Base to
determine the AutoIncrement status of a field:
C_LONGINT($1;$table_id_l)
C_LONGINT($2;$column_id_l)
C_BOOLEAN($0;$autoInc_b)
If (Count parameters>=2)
$table_id_l:=$1
$column_id_l:=$2
Begin SQL
SELECT AUTOINCREMENT
FROM _USER_COLUMNS
WHERE TABLE_ID = :$table_id_l
AND COLUMN_ID = :$column_id_l
INTO :$autoInc_b;
End SQL
$0:=$autoInc_b
End if
On my Mac's and Windows 10 machine it operates fine. On our clients
Windows machines we get an error about $table_id_l not being defined.
We haven't used SQL much... is there some underlying software that needs
to be installed on a Windows machine to make it work correctly?
Cheers
Allan
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
