Hello Massimo,
Thanks for helping.
Do you have experience using RDDSQL?
Seems very good but I am afraid I didn't understand part 3, maybe a good
example would be the answer for that. How can I save the modifications?
Regards,
Qatan
________________________________________________________
----- Original Message -----
From: "Massimo Belgrano" <mbelgr...@deltain.it>
To: "Users of the Harbour compiler" <harbour-users@harbour-project.org>
Sent: Wednesday, 12 de May de 2010 15:38
Subject: Re: [Harbour-users] Re: DBF Fast text search / SQLite
afaik last version of rddado is not working in harbour (after ole
modification)
rddsql is best choice
AFAIK RDDSQL talk directly with the sql language
this is message post by Mindaugas Kavaliauskas on this list
________________________________________________________
3. Modifying database
SSI presents a query result via RDD interface and generates no hidden
SQL queries. So, how database can be changed? Does DBAPPEND() and FIELDPUT()
works, or is it readonly SQL interface?
DBAPPEND(), FIELDPUT() and other similiar functions work on cached query
result, i.e. query can be appended by new rows and field values can be
changed, but SQL database is not changed. DBCREATE() function can also be
used to create an "empty query result" but no table is created on SQL
server.
So, SSI can also be used as implementation of "array RDD".
The programmer must call SQL command explicitly to modify SQL tables.
SSI provides a method to detect which cached rows was changed or appended.
_______________________________________________
Harbour-users mailing list (attachment size limit: 40KB)
Harbour-users@harbour-project.org
http://lists.harbour-project.org/mailman/listinfo/harbour-users
