Recent content by Don Child

Another option is to try importing everything into TwinBasic, and debug in that environment. I think 32-bit is the default compilation & is free, and 64-bit costs. I don't know if it has support for those OCXs yet.

Take care, your time chief.

It still has the Repl/Dot Prompt, Bof.

I know this ain't exactly what you're looking for, but maybe it helps . https://www.whitetown.com/how-to-convert-dbf-to-dbf/

Hi Mike, You mean "Manage Watched Threads" on the right side, correct?

Hi, I've looked at many sites and googled for the VXBase manuals, but have been unsuccessful in finding them. I did purchase the tools way back, but didn't hold onto the manuals. I think there was also a book specifically about the templates back then. But I have no clue how to even search...

Thanks Jon/gbaughma/doubledriveline, I found the Forgot Password link that you pointed out, and am back in the official profile. I don't know the answer to your question, Deniall. If I find out, I'll forward a reply.

Thanks strongm, that did the trick.

Hi, I have an oracle connection defined "Driver={Oracle in instantclient_21_6};Dbq=DB;Uid=MYUSERID;Pwd=" & ORACLE_S & ";" , and this works fine while debugging in VBSEdit, with CSCript. But the command line c:\windows\system32\CMD.EXE /C CScript.exe...

In case anyone needs this in the future, someone answered this in another forum. They pointed to https://stackoverflow.com/questions/12676747/how-to-get-the-affected-rows-in-vba-ado-execute as an example of how to get the number of rows affected by the INSERT. This answer, from the forum...

Hi, I have Set cn = CreateObject( "ADODB.Connection" ) cn.Open "Driver={SQLite3 ODBC Driver};Database=c:\XXXXXXXX\XXXXXX\XXL_XX\MYPRODDB.db;" , and it connects fine, and runs queries. The INSERT is executing fine as well, based on a query from my sql tool afterwards. THISTABLE_ins =...

All working perfectly, thanks everyone. LIST SubStr( D2LINE1, 87, 1), ChrTran( SubStr( D2LINE1, 87, 1), "+-", "-+" ) FOR SUBSTR( D2LINE1, 72, 3 ) = "BBB" to file C:\DOWNLOAD\REPL.TXT SUBSTR(d2line1,87,1) CHRTRAN(SUBSTR(d2line1,87,1),"+-","-+")...

Hi Chris, I'm already settled on doing APPEND, because then I can in effect manipulate the text file, the same way as a table. With the FiletoStr, StrToFile, I'd end up with a memo field that contains the entire file. I didn't know about CHRTRAN. That's a nice shortcut, thanks.

Yes, that's it. That's the final piece, an intermediary Search & Replace. Thanks, mjcmkrsr.

Chris, Thanks, the Xbase designers thought of everything.