> selecting a integer from the db
>
> posqlda->sqlvar[2].sqldata = (char *)&osident;
> posqlda->sqlvar[2].sqltype = SQL_LONG + 1;
> posqlda->sqlvar[2].sqllen = sizeof(field1);
> posqlda->sqlvar[2].sqlind = &flag2;
>
> selecting a smallint from the db
>
> posqlda->sqlvar[3].sqldata = (char *)&port;
> posqlda->sqlvar[3].sqltype = SQL_SHORT + 1;
> posqlda->sqlvar[3].sqllen = sizeof(field2);
> posqlda->sqlvar[3].sqlind = &flag3;
>
> what do I use for a bigint?

NIck,
if you grab a copy of the source code from FBReplicator (www.meta.com.au)
you'll have a complete header file and plenty of examples (Delphi.. but easy
enough to understand)
Alan