How to capture the data returned wSDBSelectRecords in sage 50 2016 CA SDK with Visual Basic .NET?

Question

I&acute;m using ConnectionManagerService.dll and I am using the function wSDBSelectRecords with this syntax: 
 Call wSDBSelectRecords(iDBLink, iTBLink, "", 0, True) 
 But I do not know how to capture the data you are going to select in a DataTable. I&acute;m Working with Visual Basic .NET Fraework 4.5 
 Could help me with this?

RandyW · Accepted Answer

Hi, 
 
in wSDBSelectRecords(iDBLink, iTBLink, "", 0, True), it looks like the "" is where you need a pointer to a string that contains the criteria. 
 
An empty string might contain a null terminator char 255, or nothing at all, and select no results for the next line of code to fetch. 
 
I would use one of the database utility functions as used in the sample file in the c# folder. It doesn't appear that the VB sample is as complex as the c# one, I don't know how portable it is between the .NET flavours.

Sage 50 Canada

How to capture the data returned wSDBSelectRecords in sage 50 2016 CA SDK with Visual Basic .NET?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING