External BO not showing any records

If you think that something doesn't work in Aware IM post your message here
Post Reply
Idtny
Posts: 2
Joined: Thu Feb 07, 2013 12:22 am

External BO not showing any records

Post by Idtny »

I have attached several tables from a MSSql database but one table is returning an error when queried. I know this table have hundreds of records in it and not sure why it is returning an error. The error is "Custom error". Do anyone have a reason why this is happening?
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: External BO not showing any records

Post by Jaymer »

Send me the create script for that table, and I’ll create it and connect to it and see what happens to me.
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
Idtny
Posts: 2
Joined: Thu Feb 07, 2013 12:22 am

Re: External BO not showing any records

Post by Idtny »

Jaymer wrote:Send me the create script for that table, and I’ll create it and connect to it and see what happens to me.
Thanks Jaymer. Please see attachment.
Attachments
JrnlRow.zip
(869 Bytes) Downloaded 625 times
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: External BO not showing any records

Post by aware_support »

Look at the output of the Aware IM Server - there should be some diagnostics there.
Aware IM Support Team
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: External BO not showing any records

Post by Jaymer »

I successfully created and entered a record into the SQL table via SSMS
Was able to grab the definition from SQL
Tried to go INTO test, got this error
Screen Shot 2018-03-15 at 9.57.44 PM.png
Screen Shot 2018-03-15 at 9.57.44 PM.png (13.73 KiB) Viewed 9140 times
sorry, cant go any further
v8 Build 2377

delete the BO and it goes into test just fine
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
Post Reply