Alpha DevCon 2018
Results 1 to 2 of 2

Thread: any ideas- SQL linked table ( grid component)

  1. #1
    Member
    Real Name
    mvilla25
    Join Date
    Dec 2008
    Location
    LA
    Posts
    58

    Default any ideas- SQL linked table ( grid component)

    Error executing SQL SELECT query. Database API specific error

    Your database has returned the following error code and description to Alpha Five.
    Consult your database documentation for further information.

    245 - '[Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the nvarchar value '1000BR' to data type int.
    SQL State is: 22018'

  2. #2
    Member
    Real Name
    Tony Watts
    Join Date
    Mar 2010
    Posts
    399

    Default Re: any ideas- SQL linked table ( grid component)

    Did you ever find out what was causing this error?
    I have a ux showing the same error when tying to save a record
    I am dealing with an dbf file that I upsized to SQL server

    Attachment 42869

    Tony

Similar Threads

  1. Calculated Fields in Grid based on SQL Table
    By qcorporation in forum Application Server Version 10 - Web/Browser Applications
    Replies: 2
    Last Post: 11-21-2009, 09:51 PM
  2. using SQL stored procedures in grid component design..
    By sendamail in forum Application Server Version 8
    Replies: 1
    Last Post: 04-09-2008, 05:26 AM
  3. using SQL stored procedures in grid component design..
    By sendamail in forum Alpha Five Version 8
    Replies: 0
    Last Post: 04-07-2008, 10:28 PM
  4. Grid Component Search on SQL Server Logical field
    By ldconsultants in forum Application Server Version 8
    Replies: 2
    Last Post: 06-14-2007, 04:15 PM
  5. updating table field before new record is added through grid a component
    By shkaijaz in forum Web Application Server v7
    Replies: 8
    Last Post: 04-05-2006, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •