I'm new to JBuilder (using JBuilder 4) and come from a Delphi development background. I am trying to create a small test application that retrieves/inserts/updates and deletes data in the same way I would in Delphi. I am able to retrieve data from a database table (working against a SQL server database). The only way at the curent time (admittedly I am new to JBuilder) I can see of updating data is by using a QueryResolver. Is there a component that I can use to run SQL syntax like :
"INSERT INTO [table-name]
([Field1], [Field2], ...)
VALUES
(pValue1, pValue2)"
or for an update :
"UPDATE [table-name]
SET [Field1] =pValue1,
[Field2] = pValue2
WHERE [Field3] =pValue3".
Can anyone give me a head-start with this ?
Thanks in advance,
Steve
"INSERT INTO [table-name]
([Field1], [Field2], ...)
VALUES
(pValue1, pValue2)"
or for an update :
"UPDATE [table-name]
SET [Field1] =pValue1,
[Field2] = pValue2
WHERE [Field3] =pValue3".
Can anyone give me a head-start with this ?
Thanks in advance,
Steve