-
Jul 28th, 2014, 01:03 AM
#1
Thread Starter
Member
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.
-
Aug 24th, 2014, 07:05 AM
#2
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|