U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Sql .sch / Date (moved)

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

Return to the default flat view

Create a new topic

Submit Reply

Re: Sql .sch / Date (moved) [message #35666 is a reply to message #35379]

Sun, 11 March 2012 19:30

jjacksonRIAB is currently offline

jjacksonRIAB
Messages: 221
Registered: June 2011

Experienced Member

To match them you should probably use:

TABLE_(matable)
  INT_     (ID) PRIMARY_KEY
  DATE     (SubscripDate)   
END_TABLE

or:

TABLE_(matable)
  INT_     (ID) PRIMARY_KEY
  DATETIME (SubscripDate)   
END_TABLE

using _ depending on whether first use of column name or not.

Since your table creation uses TIMESTAMP, I'm not sure how this differs on MySql. I use MSSQL and in that system I don't think that TIMESTAMP can be converted to a date. Your mileage may vary.

[Updated on: Sun, 11 March 2012 19:31]

Report message to a moderator

Send a private message to this user

[Message index]

		Sql .sch / Date (moved) By: ratah on Wed, 08 February 2012 15:42
		Re: Sql .sch / Date (moved) By: jjacksonRIAB on Sun, 11 March 2012 19:30
		Re: Sql .sch / Date (moved) By: mirek on Wed, 14 March 2012 07:49
		Re: Sql .sch / Date (moved) By: ratah on Fri, 18 May 2012 10:53
		Re: Sql .sch / Date (moved) By: BioBytes on Fri, 18 May 2012 19:38

Previous Topic:	Filling same SqlArray with different tables from database
Next Topic:	Access to S_* Structure of TABLE crash Application.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sat May 11 11:13:45 CEST 2024

Total time taken to generate the page: 0.02819 seconds