U++ framework: U++ SQL » GUID column in DB and SqlArray

Home » U++ Library support » U++ SQL » GUID column in DB and SqlArray (how to use GUID column in database app)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

[Message index]

		GUID column in DB and SqlArray By: LamerDrv on Sat, 12 March 2016 15:03
		Re: GUID column in DB and SqlArray By: mirek on Fri, 25 March 2016 19:04
		Re: GUID column in DB and SqlArray By: LamerDrv on Sun, 27 March 2016 11:48
		Re: GUID column in DB and SqlArray By: LamerDrv on Sun, 27 March 2016 14:00

Previous Topic:	How to close a sqlite session
Next Topic:	I am trying to have two sqls one to read another to write

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Apr 28 17:27:14 GMT+2 2026

Total time taken to generate the page: 0.00925 seconds