Search results for query: *

I have form that has two grids and in each I have inserted a checkbox. The check boxs expect an integer to be returned. The first grid displays without a problem, the second (when I change year) returns: Error with Column12-CurrentControl: Expression evaluated to an illegal value. I get the...

Like others who have posted this problem, I believe the problem is I can't determine the row terminator of the text file. The error I get is: Msg 4866, Level 16, State 8, Line 1 The bulk load failed. The column is too long in the data file for row 1, column 1. Verify that the field terminator...

Is there a way to setup a relationship/contraint to validate if the foreign key data matches a prime key in another table--where the field to be validated may contain nulls? The field (fkeydoc) is filled if funding is added or subtracted to the table (audit table). When payments occur the...

I have code that creates two temporary tables and then selects data from the two tables for the reporting. This works fine. When I attempt to save the code as a view it refuses saying it is disallowed for view. Get the same message SQL 2000 and 2005. Yet it allows me to create a stored...

When I attempt to update two tables using CursorAdapter I get an error message that states: "No key columns are specified for update table FMER_Companies. Use the keyfield list property of the cursor" I list two key fields, the pc_id for the FMER_PrimeContract table and the company_id for the...

I'm confused as to how a connection (to a SQL Server database) works for other users of an application. I've created a working connection (using a data source name, not a connection string)in program manager and generated an executable to run the application. On my PC I can access SQL Server...

I'm testing a procedure to update a table on a SQL Server device. The code below what I've come up with to accomplishe the update. It does give an error but does not work, that is the SQL Server table does not display the added record. My first time playing with CursorAdapter...can anyone...

When a generate a report that has colors, the PDF created by Adobe is Black and White. What would cause this? Ken

I have a one-time requirement to create a distribution list in Outlook. I have DBF table that contracts the name and email address. I want to take that data an insert into the distribution list. I'm familiar with Automation, but would gladly accept some code already done.

I'm using Redemption to send email and when email is sent and Outlook is not running the mail remains in the inbox. However is Outlook is running, the mail is dispatched. Hence how can I determine if Outlook is running?

We create PDF file using Acrobat 6.0. Later if needed the user may want to view file...is it possible to open the file using Reader 7.0? Opening with 6.0, Read/Write version is slow. Below is the code currently used to view a PDF file cPdffile = (some file name) oShell =...

I have a stored procedure that is listed in program manager but when I click the item I get a messagebox saying The database item you selected has been modified or deleted. Do yo want to refresh the project now? Yes/No. Clicking yes does nothing. You can not delete the item, only Modify...

Using VFP7/8. Want to be able to save the values of the form properties if an error is encountered. Currently capture the calling process, status, memo, etc. But not the values of form variables. How do I do that?