SELECT Format(StartDate, "Long Date") AS myFormatedDate FROM myTable ?

[Barry G. Sumpter]

Hi all,

 

Finally achieved a stable environment and making some headway.

 

 

I'm now trying to format a date field with:

SELECT Format(StartDate,"Long Date") AS myFormatedDate FROM myTable

 

5:41:40 PM: Error: Kernel error: 0x71000

5:41:40 PM: Error: 

5:41:40 PM: Error: File
..\..\..\sources\VStudio\Plugins\Valentina_2\vsV2_EmbeddedConnection.cpp,
Line 1020

 

Does anyone know how to do this thru SQL?

 

StartDate is a Date DataType.

 

Thanks,

     Barry G. Sumpter

 

  _____  

From: valentina-studio-bounces at lists.macserve.net
[mailto:valentina-studio-bounces at lists.macserve.net] On Behalf Of Barry G.
Sumpter
Sent: Thursday, 12 July 2007 3:11 PM
To: valentina-studio at lists.macserve.net
Subject: RE: Is there a way to create a M-M Binary Link in
VStudioviaaCreateLink dialog? 

 

Used google to find this:

http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documen
tation:vsql:reference:insert_link

 

LINK RECORD(1) OF Person WITH RECORD(10) OF Phone USING PersonHasPone
LINK RECORD(1) OF Person WITH (10) OF Phone USING PersonHasPone

LINK (1) OF Person WITH (10) OF Phone USING PersonHasPone

 

  _____  

From: valentina-studio-bounces at lists.macserve.net
[mailto:valentina-studio-bounces at lists.macserve.net] On Behalf Of Barry G.
Sumpter
Sent: Thursday, 12 July 2007 3:04 PM
To: valentina-studio at lists.macserve.net
Subject: RE: Is there a way to create a M-M Binary Link in VStudio
viaaCreateLink dialog? 

 

My bad.

 

I TRIED to execute the following as well in VS 3.1 SQl Editor.

 

INSERT INTO LINK link_Phone_Person VALUES( 1, 1 )   

 

But received the error:  Unexpected token: LINK

Could someone respond with the correct syntax?

 

 

  _____  

From: valentina-studio-bounces at lists.macserve.net
[mailto:valentina-studio-bounces at lists.macserve.net] On Behalf Of Barry G.
Sumpter
Sent: Thursday, 12 July 2007 3:01 PM
To: valentina-studio at lists.macserve.net
Subject: RE: Is there a way to create a M-M Binary Link in VStudio via
aCreateLink dialog? 

 

Hi all,
 
I had to execute the following in VS 3.1 SQl Editor.
 
CREATE BINARY LINK link_Phone_Person ON TABLE (Person, Phone) AS MANY TO
MANY;

 

The Table key word was NOT in the wiki and this statement would NOT execute
until the word TABLE was added.

 

Is there a way to see the content of the LINK link_Phone_Person ?

 

 

I TRIED to execute the following in VS 3.1 SQl Editor.

 

INSERT INTO LINK link_Person_Phone VALUES( 1, 1 )

 

But received the error:  Unexpected token: LINK

Could someone respond with the correct syntax?

 

Many thanks,

    Barry G. Sumpter

 

 

  _____  

From: valentina-studio-bounces at lists.macserve.net
[mailto:valentina-studio-bounces at lists.macserve.net] On Behalf Of Barry G.
Sumpter
Sent: Thursday, 12 July 2007 7:06 AM
To: valentina-studio at lists.macserve.net
Subject: Is there a way to create a M-M Binary Link in VStudio via a
CreateLink dialog? 

 


Hi all,


Is there a way to create a M-M Binary Link in VStudio via a Create Link
dialog?  


To me it would be like creating an ObjPointer but instead creating a M-M
Binary Link.


 


Binary Link Creation


To create a new Binary Link in database you send request to VDatabase
object. Database is supervisor of all its Links between Tables. 

SQL EXAMPLE: 

CREATE BINARY LINK link_Phone_Person ON (Person, Phone) AS MANY TO MANY;

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://edison.macserve.net/pipermail/valentina-studio/attachments/20070712/fe704b29/attachment.html