Alpha Video Training
Results 1 to 2 of 2

Thread: Error "Extra characters at end of expression" when LINK field is type "K"

  1. #1
    "Certified" Alphaholic
    Real Name
    Rich Fulham
    Join Date
    May 2011
    Location
    Portland, OR
    Posts
    1,021

    Default Error "Extra characters at end of expression" when LINK field is type "K"

    Does anyone use type "K" (uniqueidentifier) as a LINK field from a tabbed-UI to an updatable grid?

    I tried in V11 build 2199-3810 and 2207-3811 and I get following error displayed on the tab pane:
    Fatal error running a5_ajax_grid(): Extra characters at end of expression

    Using fields of type "K" for linking in V10.5 did not give me this error, but then again the grid had other problems under 10.5, like SOMETIMES creating bad SQL syntax.

    I really want to be able to use GUID's throughout my SQL database to tag records as belonging to a particular dataset or client. I could switch to Integer Identity columns, but I feel the data will eventually be more secure if a GUID is required to access a particular set of records.

    -Rich CPT

  2. #2
    "Certified" Alphaholic
    Real Name
    Rich Fulham
    Join Date
    May 2011
    Location
    Portland, OR
    Posts
    1,021

    Default Re: Error "Extra characters at end of expression" when LINK field is type "K"

    BTW, Build 2211-3815 contains a fix for this issue.

    - Rich CPT

Similar Threads

  1. copy previous field / record by pressing key ctrl + shift + " f " / " r " problem
    By dannysiu in forum Alpha Five Version 10 - Desktop Applications
    Replies: 3
    Last Post: 10-12-2011, 06:12 AM
  2. "File Select" Control reverts to "Type in Field"
    By Citadel in forum Alpha Five Version 9 - Desktop Applications
    Replies: 3
    Last Post: 03-03-2010, 07:22 AM
  3. "Field Display Formatting" is Lost when "Pre-fetch data for Detailed View = Active"
    By PhillipS in forum Application Server Version 9 - Web/Browser Applications
    Replies: 0
    Last Post: 07-23-2009, 11:02 PM
  4. "Add" and "Save" buttons don't stay on "Self" page
    By Scholin in forum Application Server Version 8
    Replies: 2
    Last Post: 02-05-2008, 08:50 AM
  5. Replies: 0
    Last Post: 06-06-2006, 06:08 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
  •