Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

Fri, Sep 24 2010 8:57 PM	Permanent Link
Jeff Newlin Lightspeed	Hello I'm seeing if I can migrate an application to ElevateDB and I know there is a way to have a field by the primary key field but I can't seem to find out how to do that in the CREATE DATABASE command. I'm looking for something like the ftAutoinc datatytpe that I have in my 'old' application. Also is there no "datetime' data type. I can probably pretty easily split this into DATE and TIME but I'm just curious. Thank you! Jeff
Fri, Sep 24 2010 11:20 PM	Permanent Link
Terry Swiers	Jeff, > I'm seeing if I can migrate an application to ElevateDB and I know there > is a way to have a field by the primary key field but I can't seem to find > out how to do that in the CREATE DATABASE command. I'm looking for > something like the ftAutoinc datatytpe that I have in my 'old' > application. Create the field as a Integer and make it a generated column. You can set the starting number and how much it increases with each new record. > Also is there no "datetime' data type. I can probably pretty easily split > this into DATE and TIME but I'm just curious. I think you are looking for the TimeStamp data type. -- --------------------------------------- Terry Swiers Millennium Software, Inc. http://www.1000years.com http://www.atrex.com Atrex Electronic Support Options: Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp Email: mailto:support@atrex.com Newsgroup: news://news.1000years.com/millennium.atrex Fax: 1-925-829-1851 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific) ---------------------------------------
Sat, Sep 25 2010 6:36 PM	Permanent Link
Jeff Newlin Lightspeed	Thank you Terry that's got me going again! I really appreciate the help! jeff "Terry Swiers" wrote: Jeff, > I'm seeing if I can migrate an application to ElevateDB and I know there > is a way to have a field by the primary key field but I can't seem to find > out how to do that in the CREATE DATABASE command. I'm looking for > something like the ftAutoinc datatytpe that I have in my 'old' > application. Create the field as a Integer and make it a generated column. You can set the starting number and how much it increases with each new record. > Also is there no "datetime' data type. I can probably pretty easily split > this into DATE and TIME but I'm just curious. I think you are looking for the TimeStamp data type. -- --------------------------------------- Terry Swiers Millennium Software, Inc. http://www.1000years.com http://www.atrex.com Atrex Electronic Support Options: Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp Email: mailto:support@atrex.com Newsgroup: news://news.1000years.com/millennium.atrex Fax: 1-925-829-1851 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific) ---------------------------------------
Sun, Sep 26 2010 1:10 PM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Jeff It seems as though you're trying to do everything the hard way. EDBManager is great for learning these sorts of things. You can use its menus and dialogs to carry out the actions you want and then look in SQL History to find out what the sql code was. Roy Lambert [Team Elevate]