Solved

Live Query Result set in Delphi1.6

Posted on 1997-06-27
5
173 Views
Last Modified: 2010-04-04
I'm submitting a standard query with 'like' operator in the where clause.  I'm setting Request live to True, but the program is not sending a Live Result set back.

the select statement is

select area10."FILENAME", area10."SPC_NO" from area10 where area10."SPC_NO" LIKE '%232%'

where area10 is the table name and 232 is to be found in one record of the SPC_NO field.

If I substitute "where area10."SPC_NO" = '12321' this returns a live result set, but with the like operator it does not.  The Delphi documentation state like operators should return live sets, is the documentation incorrect or am I doing something wrong.

Cheers
0
Comment
Question by:cuchulain
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 

Author Comment

by:cuchulain
ID: 1337914
Adjusted points to 200
0
 

Author Comment

by:cuchulain
ID: 1337915
Adjusted points to 230
0
 

Author Comment

by:cuchulain
ID: 1337916
please if anyone can help with this problem it would be help a lot...

0
 

Author Comment

by:cuchulain
ID: 1337917
Adjusted points to 255
0
 

Accepted Solution

by:
hsk91071997 earned 250 total points
ID: 1337918
In my code, Like operator returns a live sets.

Your Code :

  select area10."FILENAME", area10."SPC_NO" from area10 where area10."SPC_NO" LIKE '%232%'

Change your code like this
 select area."FILENAME" ,area."SPC_NO" from "area10.db" area
 where areae."SPC_NO" LIKE '%232%'

and , if you want change some field you want, insert Query's Edit method , of course you had done.

0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question