Recent content by RRiley

I have been a loyal dBase programer for years, however I am looking to expand my capabilities. If anyone has thoughts on which language to switch to, i.e. Delph or VB 6.0 or VB .net. Also can you suggest text books or training centers that you have found helpful. ADO is a big priority for me...

Morning, I am not aware of a function called NVL. Could you explain the use of this function in the native language and then maybe someone can provide the solution. I searched the OLH for SQL 2000, dBase 2.01 and Visual dBase 5.7 with no results. Thanks R2

I've done this in the past as well, this is how I went about it; //declare variables Private cline, d, q, qt, i, xWord * Open file and Determ how many spaces there are in the *text. #Define TextFile "C\Temp\Textfile.TXT" f = new File() if f.exists(TEXTFILE) //Does the file exist...

This is how I generally handle this situation. First of all the ASCII file must be in a regular repeating text that is always the same. Since we are going to rely on the repeating format we can set up a For i = 1 to x loop structure. #Define t "C:\textfiles\ASCII.TXT" //define the...

Check your ODBC file type, If you are using Microsoft Native driver change to the dBase driver, or likewise if you are using the dBase driver switch to the Microsoft native driver. Read through the MDAC information on the Microsoft website for more information on driver types and updates.

I have a ActiveX component in a container that samples for keystrokes, however dBase also samples and inputs the keystrokes causing duplications on the component. If I filter the ActiveX component using the INKey() function it works great in a Complited EXE but not when running from the...

I am using DB2K with an ActiveX Object from Rumba mainframe. All works well except the WDMFDSP.OCX interface echos or duplicats all Letters, spaces and numbers I enter into the OCX. I created the same Form in Delphi and it works with out any problems. Any Ideas? It seems to be a problem...

The original dBase format came from MR. Ashton in the late seventies when Ashton wanted a way to track Football team scores and statistics. He developed basicly the whole xBase concept and later Mr Tate came along and improved the code and helped bring it to the then infant PC market. Before...

The best way to handle this is to use Macro substition for the table name. For Example; nTable1 = Form.Entryfield1.Value //(An Entryfield on a field for the user to enter the new table name) nTable2 = Form.Entryfield2.value Select 1 Use &nTable1 Tag SomeField Select 2 Use &nTable2 Tag...

The easiest way to get around this is to have your Network admin set up a Capture command for your LPT port to route it to the Network printer. Or you can run Capture from the program using the Run command. Once the capture command is issued though all printing will go to the Network printer...

This sounds like there is a record lock on table y, most likely the program that creates this record keeps the record lock active to prevent a change from outside the program. If this is true, log off all users from the program, Shut down the program itself, Make sure the directory the table...

If you are connecting via ODBC then the same verbage used in the DBMS you are using should work on the dBase Table. However, to create an Index on a Non-Rational Database Table such as dBase you do need to establish an exclusive lock on the table to perform an index routine. This means all...

If you are use MSMail or Exchange you can do a DDE poke and execute command to create the Email message. Or you can do a DDE call to MS Word then use the Email command button in the MS Word Menu to issue an Email. The easist would be to connect to Word via DDE poke all the data into the text...

I suspect you may have a version problem with your data handling, If you open an older version(DBIV or DBIII)table in VdB and use the copy command you run the risk of re-creating the table in the new version. When you try to open the table in the older version of dBase you run into an error...

The problem withyour code for x.poke is the reference to the cell in excel. The reference should be "R1C1" for Row 1 Cell 1 rather than "A1". If you need additional info or sample code let me know. Randal