codemorphis.com Forum Index codemorphis.com
Software development: pure and simple.
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 6 matches
codemorphis.com Forum Index
Author Message
  Topic: Novice user needs help trying to make a SQL table front end
TG

Replies: 10
Views: 49536

PostForum: Visual Programming Forum   Posted: Wed Apr 11, 2007 8:14 am   Subject: Novice user needs help trying to make a SQL table front end
Wow! What a difference! The data grid populates instantly now. What was the difference in the 2 files you sent and the ones they replaced in the Synopsis install directory?
  Topic: Novice user needs help trying to make a SQL table front end
TG

Replies: 10
Views: 49536

PostForum: Visual Programming Forum   Posted: Tue Apr 10, 2007 3:38 pm   Subject: Novice user needs help trying to make a SQL table front end
Yes, the 2.5 minutes is consistent. This is a production database for an ERP system, so I'm sure the SQL backend is busy. Could the time delay be due to record locks on tables or rows? BTW, when us ...
  Topic: Novice user needs help trying to make a SQL table front end
TG

Replies: 10
Views: 49536

PostForum: Visual Programming Forum   Posted: Tue Apr 10, 2007 12:05 pm   Subject: Novice user needs help trying to make a SQL table front end
I figured it out. Sorry! It was a typo. However, it takes about 2 1/2 minutes for the data grid to populate, and there are only about 100 rows in the table. (About 27 columns). Why would the data co ...
  Topic: Novice user needs help trying to make a SQL table front end
TG

Replies: 10
Views: 49536

PostForum: Visual Programming Forum   Posted: Tue Apr 10, 2007 9:02 am   Subject: SQL OLE Error
I'm getting the following error when trying to populate the data grid...

Serv Call 1: Access Database Error: No database Open

The server is a MS SQL Server 2000. Here is my connection string:
...
  Topic: Novice user needs help trying to make a SQL table front end
TG

Replies: 10
Views: 49536

PostForum: Visual Programming Forum   Posted: Mon Apr 09, 2007 9:44 am   Subject: Thanks!!!
Thanks so much for the example! I will try to assimilate it and learn from it. The support you guys give is unmatched!

TG
  Topic: Novice user needs help trying to make a SQL table front end
TG

Replies: 10
Views: 49536

PostForum: Visual Programming Forum   Posted: Thu Apr 05, 2007 9:57 am   Subject: Novice user needs help trying to make a SQL table front end
I'm new to Synopsis and do not have a programming background, but I get around fairly well in SQL. What I would like to do is make a simple front end for a table in my SQL database, more as a learnin ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


Powered by phpBB © 2001, 2005 phpBB Group