Author |
Message |
Topic: Novice user needs help trying to make a SQL table front end |
TG
Replies: 10
Views: 52244
|
Forum: 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: 52244
|
Forum: 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: 52244
|
Forum: 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: 52244
|
Forum: 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: 52244
|
Forum: 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: 52244
|
Forum: 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 ... |
|