Updating tables from BDE/Paradox

[Darryl Wagoner]

Greetings,

I am making BDE calls to Paradox DB from MS C# and I
need to update tables with blobs and I am getting
very confused with the documentation.

What is the best way to do inserts and updates to
tables. Is it easier to do putfield or prepares?
There is blobs or I will do it with directSQL.

Can DbiPutField be done with a cursor from a
DbiQExecDirect or does it need to be a cursor
from a table and not a sql command?

PS I know that BDE isn't supported for years
and the next phase is to upgrade to a modern
DB.

thanks

[Darryl Wagoner]

Hi,

From the help files examples there is this code with the
comment about not needing a record buffer.

Is that because there is only 1 parameter in the SQL or because
only one parameter is being set with this DbiQSetParams?

// Since only one parameter is used, there is no need for a record
buffer.
// Use the Cust variable itsself.
rslt = Chk(DbiQSetParams(hStmt, 1, &FldDesc, (pBYTE)&Cust));
if (rslt != DBIERR_NONE)
{
DbiQFree(&hStmt);
return rslt;
}

thanks