Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Sorting a grid

  1. #11
    Member
    Join Date
    Apr 2013
    Posts
    88
    It seems I have the same problem when using virtual tables mapping MS SQL Server tables.
    2 virtual tables in 2 form sections. All DML operations are ok on 1st form while 2nd form attemps to use 1st form cursor.
    Tried unsuccessfully to use 'select t2' to make sure the correct cursor was referenced in various section delegates (activate, before create), should it be done an another way?
    Regards

  2. #12
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,379
    Can you explain further what you are seeing and any error messages reported in the Console?

    Thanks,

    Yvonne

  3. #13
    Member
    Join Date
    Apr 2013
    Posts
    88
    table city columns (cityid (int), cityname (char), cityupd (char)) (page1 section1)
    all DML operations on city are successful

    table member columns (memberid (int), membername (char), memberupd (char)) (page2 section1)
    when inserting in member i get
    Mon Jun 10 13:25:05 2013
    **** Lianja error ****
    APPEND BLANK
    ^
    [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'CITYID'. [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'CITYNAME'. [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'CITYUPD'.

    It looks like the insert is being performed against "City" and not "Member"

    Regards

  4. #14
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,379
    I have been able to reproduce this behaviour and have submitted a ticket.

    Thanks,

    Yvonne

Page 2 of 2 FirstFirst 12

Tags for this Thread

Bookmarks

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
  •  
Journey into the Cloud
Join us