Results 1 to 2 of 2

Thread: Shadow Direct 7.3

  1. #1

    Thread Starter
    Member
    Join Date
    Aug 2013
    Posts
    42

    Shadow Direct 7.3

    I have faced a weird problem in my project with Shadow Direct 7.3. Let me explain my problem in brief.

    I have shadow program(Written in 2000) which will execute the query(Select, Update, Insert and Delete) dynamically. This shadow is working fine with all the previous versions of shadow direct(3.1,6.1,6.7). But it is acting weird with Shadow direct 7.3.

    Here is my problem

    Below is the query i used.

    FIELD1 - INTEGER
    FIELD2 - CHAR(2)
    FIELD3 - DECIMAL(6,0)
    FILED4 - CHAR(2)
    FIELD5 - CHAR(10)

    SELECT FIELD1,FIELD2,FIELD3,FIELD4,FIELD5 FROM TABLE

    Which is giving proper values while executing the shadow with older versions of data direct.

    But i am getting some junk values for FIELD3(Decimal) while executing from SHADOW DIRECT 7.3.
    Example: In table i have 0 for this filed but the value coming from shadow is 4.

    Also this issue is happening only when FIELD4 and FILED5 are NULL.

    Also if i change the order of select query i.e if i keep the FILED3 filed at last the results are fine.
    SELECT FIELD1,FIELD2,FIELD4,FIELD5,FIELD3 FROM TABLE

    or if i convert the DECIMAL field to INT the results are coming fine.
    SELECT FIELD1,FIELD2,INT(FIELD3),FIELD4,FIELD5 FROM TABLE

    i am not able to find whether the issue is with Shadow program or Shadow Direct 7.3.

    Do we need to set any properties for the Shadow Direct 7.3 for decimal fields. I am pretty sure that some compatibility issue with shadow direct 7.3.

    Any idea guys??? - Bit urgent.

  2. #2
    PowerPoster Nightwalker83's Avatar
    Join Date
    Dec 2001
    Location
    Adelaide, Australia
    Posts
    13,344

    Re: Shadow Direct 7.3

    What do you mean by junk values?

    Edit:

    Which company created the software?
    Last edited by Nightwalker83; Aug 24th, 2014 at 07:34 AM. Reason: Adding more!
    when you quote a post could you please do it via the "Reply With Quote" button or if it multiple post click the "''+" button then "Reply With Quote" button.
    If this thread is finished with please mark it "Resolved" by selecting "Mark thread resolved" from the "Thread tools" drop-down menu.
    https://get.cryptobrowser.site/30/4111672

Posting Permissions

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



Click Here to Expand Forum to Full Width