sql statement using data environment - Xtreme Visual Basic Talk

10-26-2007, 01:36 AM

ejbagz

Newcomer

Join Date: Jul 2007

Posts: 16

sql statement using data environment

hi. im trying to make a search engine in vb. the process is when i type a name in the test box, the result will show in an flexgrid.

i have this code in my text bow

Code:

 
with dataenvironment1
set mshflexgrid1.recordset = .rcommand1
end with

the sql statement in my sql builder is

Code:

 
select info.* from info
where info.name like ' &text1.text& &#37;'

the problem is that it doesnt show the list but if i remove the where statement it shows the whole data. i want to know what is the correct sql ststement and wat is the correct syntax in displaying the result in a flexgrid

Last edited by ejbagz; 10-26-2007 at 01:38 AM. Reason: the code is not right

10-29-2007, 04:01 AM

Shurik12

Steppe Walker

Retired Moderator
* Expert *

Join Date: Jul 2002

Location: Ukraine/Russia/Belgium

Posts: 7,227

Hi,

Code:

select * from info
where [name] like  '" & text1.text & "%'"

Another thing is that you don't want to use DataEnvironment but ADO objects
instead (ADO Tutorial)

__________________
"A diaper is not like a computer that makes satisfying burbling noises from time to time, hinting at great inner complexity." Malcolm Gladwell

"I'm sitting here completely surrounded by no beer." Onslow, 'Keeping up appearances'

Posting Rules

You may not post new threads

You may not post replies

You may not post attachments

You may not edit your posts

BB code is On

Smilies are On

[IMG] code is Off

HTML code is Off

Forum Rules