Result of local SQL query CANNOT modify !!

feli...@hka.online.edu (Felix Ng)

Delphi Developer

Mon, 08 Jun 1998 03:00:00 GMT

Result of local SQL query CANNOT modify !!

Quote

151.2.31...@IT.net wrote:

> Hi,

> I am a newer Delphi programmer; I have seen your article in the newsgroup
> \..\database
> and I tell you that's also my problem.
> I have seen that many people have the same problem.
> Have you actually fixed in anyway the problem ?

> If yes, may you help me and tell me your solution ?

> I am trying new way...

> Unfortunately I have only tomorrow (22/ 12/ 95) for read your response.

Some said that is pronblem only occur in local sql. So, DON'T use
TQuery for local database. You can use TTable instead.

Use INDEX --> order by clause
Use filter --> where clause

Get some filter component from the Delphi Super Page :
http://sunsite.icm.edu.pl/archive/delphi/

Try the "dbfilt16.zip", It's cool !

Best Regards
Felix

Alle

Delphi Developer

Tue, 09 Jun 1998 03:00:00 GMT

Re:Result of local SQL query CANNOT modify !!

Quote

feli...@hka.online.edu (Felix Ng) wrote:
>151.2.31...@IT.net wrote:

>> Hi,

>> I am a newer Delphi programmer; I have seen your article in the newsgroup
>> \..\database
>> and I tell you that's also my problem.
>> I have seen that many people have the same problem.
>> Have you actually fixed in anyway the problem ?

>> If yes, may you help me and tell me your solution ?

>> I am trying new way...

>> Unfortunately I have only tomorrow (22/ 12/ 95) for read your response.
>Some said that is pronblem only occur in local sql. So, DON'T use
>TQuery for local database. You can use TTable instead.
>Use INDEX --> order by clause
>Use filter --> where clause
>Get some filter component from the Delphi Super Page :
>http://sunsite.icm.edu.pl/archive/delphi/
>Try the "dbfilt16.zip", It's cool !
>Best Regards
>Felix

Hi,

I did not see the earlier messages, however, the usual reason (beyond
the primary key or an index not allowing it) that people have not been
able to modify the result of a query is that the RequestLive property
does not like the format of their SQL statement.

Take a look in The Delphi Super Page
(http://sunsite.icm.edu.pl/archive/delphi/) in the freeware section
for a program named SQLDEMO.ZIP from Allen M. Servedio (me!). I take
the data from TEdit and TMemo fields and either Insert, Update, or
Delete from the database (according to what you specify).

Good Luck,
Allen

Other Threads

1. result of local SQL query CANNOT modify !!

2. modifying result of a query

3. help: querying the results of a SQL Query...

4. Local sql, query on query problem

5. Query of a query (with Local SQL)...?

6. How to I save results from a Local Query

7. Local SQL, works in MS SQL, not in local SQL

8. Modifying records in a read-only SQL result set

9. MS SQL 6.5 vs Local SQL Query

10. Local SQL: cannot use alias in where-statement