HELP!!!!

[Guest_imported]

Anyone please help me to write a program in Visual Basic 6 to read a database in text file (.txt) and then compare with the input value in text box to see if this value are already placed in database or not????

 

[Bastien]

why not do a search on the Db instead. way quicker and easier to boot.

just hit the Db and try to select the item
if the number of rows returned by the query is zero then
insert
else
write item already in Db
end if

hth Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[lesina]

Hi Steven82au,

first of all, open the file:

Open "C:\myfile.txt" for input as #1

second: put the input value on a variable (or not, you don't need this)

valor=textbox1.text
dim sim as boolean 
sim =false

third: search the file for the value

WHILE NOT Eof(1)
LINE INPUT #1, temp$
if (temp$==valor) then
sim=true
WEND

now, if the boolean "sim" is false, you dont't have that value in the file, otherwise, it's there alright.

last but not least close the file:

Close #1

===================
* Marta Oliveira *
===================
marta100@aeiou.pt
-------------------
CPC_TA- Braga
-------------------
Portugal
===================

 

[Guest_imported]

Hi all!
I'd like to thank all of you so much!! I've already done the program sucessfully with your helps.