Search results for query: *

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...

...queries. The INSERT is executing fine as well, based on a query from my sql tool afterwards. THISTABLE_ins = "INSERT INTO [THISTABLE] SELECT * FROM [THATTRANSACTIONTABLE] WHERE [Filename] = " & "'" & THISFileName_s & "'" & " AND [status] = 'F'" cn.Execute( THISTABLE_ins ) , but my...

...REPLACE D2LINE1 WITH LEFT(D2LINE1,86) + ChrTran( SubStr( D2LINE1, 87, 1), "+-", "-+" ) + SUBSTR(D2LINE1, 88, 166 ) FOR SUBSTR( D2LINE1, 72, 3 ) = "BBB" *** Confirmed reversed signs in the table ***

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.

Hi mjcmkrsr and Chris, Yep, I figured filetostr would be necessary, but couldn't figure out how we could perform something similar to table manipulations. I would still have to specify the exact location on each line where the specific pluses and minuses are, since that might be other...

Hi, Normally if I have a text file with line lengths less than 255, I can APPEND the text file into a table, manipulate the lines in the table, then output the changes to another text file. But the text files I'm working with, have line lengths of around 1000 characters. The line length is...

Chris, I don't know how the software goes about doing the conversions of the index names, but I'm using DBConvert Access to Foxpro. I purchased a license in 2012, and am upgrading it today, for this new project. It worked fine the last time I used but, but I don't recall what happened with...

Mike - envious. Never attended any of the conferences. Dbase itself is still alive and kicking, they even sell Dbase V for Dos. Chris - Never knew that, about the DBF containing an indicating of it's umbrella DBC. Very useful, I'm now more excited about playing with Foxpro. Mike -...

Perfect, thanks Scott/Mike/Chris. I play in Dosbox on my android tablet sometimes, and still use some of the original Dot Prompts. So the terminology is literally like yesterday.

The command tool that shows up when you run VFX. It's been there since the beginning, in fact way back with Dbase. Even the modern xbase compilers all have repls to type in queries on the fly. In the Dbase days, it was called the Dot Prompt.

Hi, I'm thinking about converting an Access database to foxpro, because I do a lot of ad hoc queries and manipulation when there are problems. If I convert the .mdb (not .accdb) to a Foxpro database in a dbc, will I be able to access the longer field names from the repl?