Search results for query: *

Mike/Olaf Thanks for your help. I have the two grids running thought I'm not quite certain why both work now. I thought I had previously set the recordsource to a blank string, regenerating the cursor and then resetting the recordsource (and it did not work yesterday). I started again to...

Olaf, I responded to Mike that the data source is 0 or a higher integer. I have used this construction for years, if the field is greater than zero, the box is checked. I do want to use the same cursor name, but your comment I can empty the original cursor and refill is interesting...I will...

I did check that each cursor had the required field and was the correct data type. I saved each cursor to a table and compared the fields. Each contains a field named "custimage". Each was filled with a zero (no image of the customer document) or a higher integer (document key assigned by SQL...

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...

I was able to load the text file. I found the I needed to use the hex decimal code of '0x0a' to identify the line feed character..

Thanks for replying, I will check this out on Monday and let you know.

I'm using SQL Server 2005. I'm unfamiliar with SSIS, DTS, etc, but wouldn't I still need to be able to determine the row terminator? For what it's worth, I opened the text file in VFP and saved it. I could then use bulk insert with the "new" text file. This text file is essentially one field...

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...

Using SQL Server 2000, hence not allowed to use a select statement in a constraint.

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...

Thanks RiverGuy, thought I would ask...

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...

Mike, Thanks for help, I've decided to use the raw connection string. I discovered the reason for the dialog box I was getting was due to my failure construct the string properly. Your mention of the text file for the ODBC parameter pointed that out to me. Thanks!!

I did experiment with connection string (a DSNLess connection) but it seems to always open a dialog asking for a name of DSN. Maybe I'm doing something wrong. I did find the text file with the connection settings...to continue your thought, add this file to the project and have the loader...

Some of the clients who run the application use Government PCs which prohibit changes to the registry by the user, so a registry update won't work in all cases. If I use a connection string versus a DSN, how does that work? I've read you can issue a "DSN Less" string. When I tried that a...

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...

Tamar, I discovered that error yesterday and made the correction. That did not resolve the problem. To ensure I didn't have an insertcmd error, I ran a selectcmd to extract records and then added a record to the cursor and called tableupdate with buffermodeoverride set to 5. No change...it...

As you suggested I added the updatablefieldlist and updatenamelist properties and set sendupdates to true. I also changed the keyfield to reflect the primary key field which is set to increment by 1. It still does not error, but does not update. What am I missing? ----- lcConnString =...

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...