Search results for query: *

If I am using RDO to connect to a database, how do I get a count of the number of fields in that database?

How do I pass a variable from a FoxPro app to a VB app? Thanks.

I have this code: ----- for i = 1 to dbs ?mfolder(i) md mfolder(i) endfor ----- mfolder is an array contain strings, and I want to make a folder named for what is in the array. When I run this, it gives me the error "Not a character expression," but it still creates the folder. Any help...

Is there any way to export an entire Excel file so each worksheet is individually exported to separate text files in one action, instead of separately exporting each sheet? If there is any way to do this in Excel, or a program that will will help, please let me know. Thanks.

This is a pretty basic easy question I should know, but alas... When something talks about the number of simultaneous connections an Access database can handle, is it referring to connections to anywhere in the database or just connections to the same table?

I have a built-in nVidea card, plus an AGP Radeon card in my computer, and I'd like to be able to hook a monitor up to each for dual desktop. When I turn turn the computer on, it automatically uses the Radeon and not the nVidea, in fact, the nVidea card isn't even displayed under display...

Here's the situation. I have created a little app that uses RDO to connect to a FoxPro DBF database. The program and the database are housed on a server, which users connect to (these users do not have Visual FoxPro installed on their systems). I had to update their VFPODBC.dll file to allow...

I am using RDO to connect to a FoxPro DBF database in VB6. When I display the contents of a field in a text box, and then try to edit that text box, it won't let me type in any more characters than that record had in it initially. For example, if in the last name field is the last name...

I'm writing a VB program for my company that deals with their phone lists. It searches through the list and creates a recordset based on the entered criteria. It then allows the user to edit the records. If a record is edited to the point where it no longer matches the search criteria, VB...

How do I get a FoxPro DBF file to work with ASP? I have the following connection string working with an Access MDB: strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("cooproductions.mdb") What does the provider part need to be to work with a DBF? Thanks!

Silly question really. If you're running a FoxPro program, and in that program is a select statement, FoxPro will open up the results in a window. Is there a way, programatically, to make the results not open up like that? Thanks.

I have a table in Access with columns 'm' and 'j', and I need to run a query to put the average of those two columns in another columns. Here is what I tried: update table set average =(m+j)/2; This, however, completely cuts off the decimals, even though the 'average' column is set for 3...

Another question from me :) I'm quite new to FoxPro programming, so I often come across things that I have no idea why they're not working. Take the below code.... -------------------------- dimen clist(255) && List of names for each column dimen cuniq(255) && List of unique counts for each...

I want the below code to loop through each field and index in (thus showing the unique count for each field). But it just counts 1 unique for each field (which is not accurate). How can I do this? Is there a completely different way? Thanks. numFields=aFields(aColumns) set safety off set...

I'm making a message board for my website using ASP. For inserting new messages into the database, I have this SQL statement: insert into guestbook (name,email,private,message,date) values('qwert','y','on','yweyyyy!!!','6/14/2005'); Name and email are text type, private is yes/no, message is...

When running a batch file, how do you get it out of 8-character maximum mode?

Sorry for posting so many questions today. Below is a program meant to put records into a standard format. Under the last name section, for some reason, if the column name is lname1, it won't change it to lname (but will for the other variations of last name). Same for first name. Any idea...

I'm trying to create a program that will help us with formatting phone lists. It searches to see if the lname1 field exists, and if not, finds fields that may be the last name field and renames them. I'll run this when there is no lname1 field but there is one of the others, it always gives me...

I'm brand new to FoxPro coding. Can someone tell me why the below code gives me an error that says ' An IF | ELSE | ENDIF statement is missing.', at the if x = 0 line. Thanks. set stat on x = 0 numFields=aFields(aColumns) For i=1 To numFields If Upper(aColumns(i,1))='lname1' x = 1...

This code: <a href="#" onclick="document.cardsearch.cRing.checked = true;">Click</a> When you click the link, it does the onclick but then goes to the top of the page. How do I have the onclick text link not change position on the page? Thanks.