Topic Options
#47129 - 09/08/15 08:12 AM Grid View and SQL Communication
DanielTurski Offline
New Guy

Registered: 09/01/15
Posts: 5
Loc: Waterloo, Ontario
Hello all,

I'm currently brushing up on my SQL, and I've heard that navigating Grid View with SQL is possible. Are there any tutorials available to see how it works?

Thank you.

Daniel Turski

Top
#47130 - 09/08/15 08:55 AM Re: Grid View and SQL Communication [Re: DanielTurski]
Bruce Gardner Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3615
Loc: Toronto ON, Canada
GridView 9.2 can load information to a SQL database.

Softrak's YouTube channel has a video that describes the features in GridView 9.2: GV 9.2 new features

The portion on exporting to Access or SQL starts at the 4 minute mark. The video focuses on Access because that is expected to be more common among Adagio users but the concept applies to SQL.

What are you trying to accomplish?
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#47138 - 09/08/15 12:16 PM Re: Grid View and SQL Communication [Re: Bruce Gardner]
Michael Mulrooney Offline
Adagio Virtuoso

Registered: 02/07/02
Posts: 839
Loc: Vancouver, BC
GridView can also View tables in a SQL database.
A file DSN pointing to the SQL database must exist in the data folder used when opening GridView AND Include External Tables must be selected in the Defaults.

Top


Moderator:  Softrak Support 
Who's Online
1 registered (Samuel Kopstick), 68 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14474 Topics
70690 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31