Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gaelin

    Check Box in Grid Illegal Value

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

    Check Box in Grid Illegal Value

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

    Check Box in Grid Illegal Value

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

    Check Box in Grid Illegal Value

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

    Bulk Insert Help

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

    Bulk Insert Help

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

    Bulk Insert Help

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

    Bulk Insert Help

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

    Validate Relationship

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

    Validate Relationship

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

    Temporary Table in a View?

    Thanks RiverGuy, thought I would ask...
  12. gaelin

    Temporary Table in a View?

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

    CursorAdapter--Updating Two Tables

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

    Use of a Connection in Program Manager

    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!!
  15. gaelin

    Use of a Connection in Program Manager

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

    Use of a Connection in Program Manager

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

    Use of a Connection in Program Manager

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

    CursorAdaper Insert

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

    CursorAdaper Insert

    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 =...
  20. gaelin

    CursorAdaper Insert

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

Part and Inventory Search

Back
Top