Search results for query: *

I am trying to learn php to manipulate MySQL data. I setup a simple input form and a script to insert a record to the database. I tried the code in a working web site which is hosted on GoDaddy and it works fine, but when I try it in my local practice machine it won't insert the record and I do...

I am trying to learn php to manipulate MySQL data. I setup a simple input form and a script to insert a record to the database. I tried the code in a working web site and it works fine, but when I try it in my local practice machine it won't insert the record, but I do not receive any errors...

I am using CR-2011 to extract daily sales order totals. The orders/totals have to be grouped by salesperson by customer and by order. In the order detail table I don't have a line total, I created a formula for this purpose, I then created 3 summaries to add the total of all like totals, the...

Hello, I am using VPF 9.0 SP2 trying to extract data from an MS SQL Express 2008. I am getting an error of "is not a table" when I try to append from an offline view. I tried deleting and re-creating everything, but I am still having the problem. I can do an "use vbom" to open the offline view...

Hello, I am working with VPF9 SP2 pulling data from an MS SQL 2005 server. I create views and sometimes I have to delete them to recreate them with different criteria. If the view I am trying to delete does not exist I get an error and the program stops, is there a way to trap this and deal...

Hello, I am running VFP9 SP2 to extract data from an MS SQL 2000 DB. I would like to use a field on a VFP stand alone table as a list for the WHERE clause, but I am getting an error. I would like to know if you can see what I am doing wrong from the code I am using below: CREATE SQL VIEW...

I am using VFP 9.0 SP2 and need select records based on an MS Access Boolean true/false record. I am stumped, I have tried many different ways using =0, =false, etc. Is there a way to make this work? I will greatly appreciate your feedback.

Hello, I have an Excel spreadsheet that I need to save as a CSV file, I wonder if this is doable from within VFP? I output the spreadsheet from within VPF and then run a routine to change the column headers and width, that all works fine, but I can't figure out how to tell VPF to save as a...

Hello, I am trying to learn to view and print Crystal reports from within VFP 9 SP2 and I am not getting results, I wonder if what I am trying to do will even work. I have Crystal Reports 2008 installed in my computer, is VFP able to view reports saved with this version? In IntelliSense I...

Hello, I need to do some field value replacements across multiple tables; rather than rewrite the procedure for every table (around 100 of) them, I would like to setup a table with a list of the table name / field name and have a single block of code cycle to through the list. Basically I am...

Hello, I am new to VB 2008, I am trying to practice on a small application to update a table containing sales person information, I am trying to setup a check to make sure no one updated the record in the interim before sending the update, I save the current values in a set of oldXXX local...

Hello, I am working with a MS SQL Server 2005 database, I need to return the value of the last field in a group and I am having a problem getting it to work, the data comes from 2 different tables as follows: StatusOptions.StatusNumber StatusOptions.Description StatusDetails.ID (incremented...

Hello, I am starting to learn VB2008 coming from a VF9 background, I am trying to figure how I can connect to 2 different SQL servers to extract data from both merged into one dataset. I have the first connection setup and working, but I am lost as to how to add the 2nd, I setup a class for the...

Hello, I am using VFP 9 SP2, I have a table that contains the following fields: stockcode, jan, feb, mar .... dec The fields contain negative, zero and positive data, I need to reverse the sign before merging the data into another table, I am doing this now with a do while loop, but I am...

I have 2 tables in VFP9, I need to update records from the secondary table into the main table, I have been doing this using do while loops, but I am wondering if there is a more efficient way to do this. The main table is: sales.stockcode, sales.yeartodate, sales.lastyear, etc. which are...

Hello, I have 2 tables that I need to consolidate into one, I usually do this using a do while loop, but I am wondering if there is an easier way. All 3 tables have the following structure: stockcode, january, february, march, etc. I have to sum each pair of months into a single row for each...

I am using VFP 9.0 SP2 with data from a MS SQL 2000 server. I need to come up with monthly sales qtys per item per month for the current year. I have code that will give me a row per stockcode per month, but I would like to see if I can return a single row per stockcode with a column for every...

Hello, I am using VFP 9 to come up with a list of duplicate records in a remote view, I have this working, but I end up with a list that shows a full list of duplicates, I would like to weed this out so that it only shows me one entry per duplicate record and I am stuck trying to get this done...

Hello, I am using VFP 9.0 manipulating data on a single table MS SQL 2005 database. What I am trying to do is dump the content of the table nightly and upload new records, there are about 13k records and about 90% of them become obsolete daily, that I why I rather wipe out the data and upload...

I am wondering if it is possible to use the values in a FoxPro table as the list for a where field in () criteria? In my case I have 2 tables as follows: InvMaster.StockCode InvStructure.Parent InvStructure.Child I would like to setup something like: AS Select InvStructure.Parent...