Search results for query: *

Ok, If I follow, this would work?? USE Remote_view BROWSE ... make changes to records TABLEUPDATE()

I have just started using MSSQL 2005 as a r/w data source for my client. This is new territory for me as I have always used local VFP databases and read only views in the past. What I want to know is if I can use a remote view to BROWSE data and then use the BROWSE grid to make updates? The...

Answer: BRAIN FREEZE Ok, color me blushing. I totally forgot about using: append from DBF("cursorname") I was stuck in a different mindset. This was a good exercise none the less as I had the same issue with another array in the code that I could not do without. Jon

I have an ODBC result cursor that has 6000+ rows reported. I am trying to feed it into a VFP9 table. My plan was simple: <LOOP for tables> <ODBC query run here> COPY TO ARRAY aname SELECT table APPEND FROM ARRAY aname <ENDLOOP> My problem is that the array only loads 2748 records...

Group, thanks for all the feedback. I was able to create the function I needed using all of the information toy provided. This saved me a ton of trial and error. This is why these forums are great! Jon

I am looking for a simple function to take a string containing a phone number, strip non numeric out and return a standard output string. ex. (555) 345-3545 = (555)345-3535 ex. 555-345-3545 = (555)345-3535 ex. 5553453545 = (555)345-3535 I could write this myself but why reinvent the wheel. Jon B

My user connected to a shared mailbox on an Exchange 2003 server and attempts to change the name of a folder under inbox. The change looks good but after log off/on the folder is reverted back to original name. They have full rights to the mailbox and a user with exact same rights can make the...

This has been discussed before but the threads are old and I want to revisit it. I want to connect to MAS90 via the normal ODBC driver and PHP to the database found on a second server within the same local domain. Goal: Mirror MAS90 data into MySQL database on webserver for daily reporting -...

I need to dump selected tables from 3.71 to a more easy to work with database format. I would like a utility or set of scripts that can be run on a local server to populate a mySQL database for PHP based reports and extracts. My managers need reports that are too complex and unstable to be...

Update: I decided to dump the data out and import it directly to new tables in VFP9. I had to use the ~ as a seperator but it did the job. I setup a script that will refresh the VFP files in about 15 minutes. There are a few processing steps that are needed to cleanse the data but it works...

I have several large Sqlite3 databases that need to be converted into VFP tables and finally to SQLServer tables. My problem is that the Sqlite tables do not want to just carry over to VFP with a simple append or scatter gather. The data was not very well designed and it is truncating or...