Hi we'd like to ask if there's a way to get a list of results from the database using a Select Statement. Below is a part of our code, which we think only gives us one result field, whereas what we need is a list of results for us to display onto the macro scheduler dialog. Thanks in advance. . . . ...

Hi, We wrote a piece of macroscript code in order to copy a portion of text from a text file to another text file. part of the code is as follows: Run Program>C:\Program Files\Windows NT\Accessories\wordpad.exe WaitWindowOpen>Document - WordPad WindowAction>1,Document - WordPad //open source file Wa...

ok! thanks!

Hi sorry i got another problem now I tried to perform an Insert Into. 'Temp' variable contains values that i retrieved from notepad. However, the data that was inserted into the database is always (1, blank space). Is it because 'temp' is outside VBSTART and VBEND? if so, how do i go about correctin...

It worked! Thanks!!

Erm how do you check what value is actually taken in? How do we print out the value? Sorry I'm a total newbie :P After changing the final line to Set rs = MyDB.Execute("INSERT INTO carriertest VALUES('3', 'temp');") I now get an error message Specified Window "rs = MyDB.Execute("INSERT INTO carriert...

Hi i'm trying to connect to MySQL Database using ODBC Connection Driver. There was no error message when i executed it, but my database doesn't seem to be updated. Any form of help will be greatly appreciated! Below is my code Dim MyDB : MyDB=Server.CreateObject("ADODB.Connection") MyDB.open "Driver...