cbjax

Yea, I'm getting an error running this test version above. Thanks.

Found the source. Thanks.

Whoops, not the source.

Never mind, followed link - got it . Thanks.

I just ran it and I have Win7 64 bit and it looks great. Source?

that's it. thanks a bunch.

Haven't done but a couple of these, hope this is right. I copied this (see attached) code from xenobiolotist, I think. Got it to work with a DBF file but would like to use a variable for the file name in the 2 procedures instead of ltl_rates.dbf otherwise it does what i want to do for the moment. When i get the variable to work then I will try some other things with this script. BTW: i do not see how to include the code directly. I'm sure it's right there but i do not see it. Thanks dbfRead.au3

You are correct I did mix it up, I was testing with select to see what would work and didn't make them all the same. However you fixed it, your last suggestion worked. Thanks a bunch.

The uncommented line worked and the other 2 that are commented out did not. Does anyone see something that might help delete with a variable? Obviously for this to work I need to be able to delete by a variable. $objConn.Execute("delete from h1lordr1 where HT_ORDER_NUMB = '468390 ' " ) ; ;$objConn.Execute('select * from h1lordr1 where HT_ORDER_NUMB = "' & $ord_no & '"') ; ;$objConn.Execute("select * from h1lordr1 where HT_ORDER_NUMB = " & $ord_no ) Thanks again for listening!!!!

Neither of the suggestions worked but I do appreciate the attempt anyway.It is not a well known product, so I may be chasing my ..... Thanks

Can i press my luck? I now need to delete records from the table and I've tried various versions of below with no success. I get this message "The requested action with this object has failed" for the delete line. I do not know if it matters, but ht_order_numb is a 32 character string $ord_no = 123455 ! I've tried with and with out the single quotes. Func _delHeader($ord_no) $objConn.Execute("delete from h1lordr1 where HT_ORDER_NUMB = " &$ord_no ) EndFunc ;==>_delHeader Thanks in advance.

Dynamite, worked like a charm. Thanks

The commented out select statement below works fine, but I need to be able to use a variable and I've tried several versions of the uncommented out line and can't get it to work. Any help would be greatly appreciated. And yes I've been reading post for a day & a half concerning adodb, odbc, select, etc. BTW: I'm fairly new to AutoIT, been a basic programmer for a long time though. $objConn = ObjCreate("ADODB.Connection") $objConn.Open ("Dsn=xxxxxxxxxx") ; not relevant to issue I don't think #EndRegion This works fine ;$rsDetails = $objConn.Execute("SELECT * FROM oddetailchg where OdOrdNo = 303451") This doesn't work $ord_no = 303451 $rsDetails = $objConn.Execute("SELECT * FROM oddetailchg where OdOrdNo = $ord_no ")

Not sure if this is what you need or not, if you can get the co-ordinates of the window to serach and do the following. the $result will not be = to 0 if the quoted text is found in the clipboard. I found it somewhat tricky to figure out what the window co-ordinates are to read but once I did I can read almost any non window (text windows, terminal emulation products and such) window. MouseClickDrag("Left",10,90,770,600,5) Send("{LCTRL V}") $READ = ClipGet() $RESULT = StringInStr($READ , "whatever text you expect in the window") Sleep(1000) If $RESULT <> 0 Then do whatever means text was found in string endif Hope this helps