U++ forum: Welcome to the forum

GUID column in DB and SqlArray [message #46124]

Sat, 12 March 2016 15:03

LamerDrv
Messages: 3
Registered: March 2016

Junior Member

Hi.

I try create simple one-form database app with two master-detail grids. I take SqlArray example as base.
But in my case the DBMS is MSSQL. And PK field in my master table and detail table is uniqueidentifier type (i.e. guid). And foreign key in detail table is uniqueidentifier.
I needn't show guid columns in SqlArray - I will show only human-readable fields.

As much as I understand, I can't provide guid field definition in sch-file. Is that right?
Is any benefits from use sch-file in project if that file providing non-full definition for my tables?
Need I use SqlArray.AddKey(ID) for primary key guid column?
What about SqlArray.Join?

Please, can you to provide small sample how to use master-detail SqlArrays whit db tables that contains guid columns?
Thanks.

Report message to a moderator