I created a datawindow which is using an Ado server (created in VO).
Some basic questions:
1) in the Ado Server I can add an additional property reading
"WhereClause". However, I would like to use the "WhereClause" in my
app as parameter giving the user the option to specify what data
should be retrieved, filling the Whereclause and afterward using the
Ado Server class as created from the "Tools", "Ado Server" option in
VO2.7. Not fully clear where to specify my "WhereClause" in a running
application.
2) in my datawindow (using the SQL server as defined in the Ado
Server) I simply put a statement
: self:oSFData_Sub:server:delete() to delete one selected row. I would
now know why I should delete a single record using SQL statements to
delete a SQL record. Is this approach ok?
3) see above. But now for going to the bottom & top record. I simply
put : self:oSFData_Sub:server:gotop(0
4) why does the self:oSFData_Sub:server:append() not work? Is this
because I should use the SQL INSERT statement instead or is this
because you can not append an empty record in case you created a
Primary KEY with "NOT NULL"?
5) what is meant by a cursor? I see this term coming back every time.
6) VO's CDRom does include a variety of ADO examples. For me the exact
usage of the AdoRecordSet is still not clear. When are you using this
in your VO applications?
I know.... basic questions but just following a step by step
approach... So far I'am very impressed on SQL Express, SQL Server
Management Studio Express and ADO. It is only difficult to get the
pieces together but we make some progress....
Thks for any feedback on the above.
Rob
