MapForums
Community of VE/MapPoint Users and Developers
import query with importdata method in VB.net
This is a discussion on import query with importdata method in VB.net within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Hi, To import an existing query with this method works good... Can I use SQL directly in the method? like ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
01-20-2004
| |||
| |||
| import query with importdata method in VB.net To import an existing query with this method works good... Can I use SQL directly in the method? like .importdata(database.mdb!"Select * From Table") It didn't work when I tried... If not , how can I create and put a query in my database with VB.NET code? thanks for help, Wim         |
|
01-20-2004
| ||||
| ||||
|
It's been a while since I worked with it, but as I remember it was limited as you are finding. Specifically I could not pass a parameter value, I could only load set the pre-exisitng queries. The workaround I found was to write a value to a dummy table that help the parameter values. You might be able to do something similar. If you want to construct your SQL statements on the fly and pass them in, perhaps you can create a Query object in the acccess table? and then call your query object. Good luck, Eric
__________________ |
|
01-20-2004
| |||
| |||
|
Thanks Eric! Thats what I'm looking for to create and save a query object in access by vb code.... But thanks again for your idea to save only the query parameters in a dummy table. So now I have to find out how to make a query that uses some fields in that dummy table as parameters. Regards, wim |
|
01-20-2004
| ||||
| ||||
|
The dummy table would be one of the tables in your query and linked to your main table. Eric
__________________ |
 |
| Tags |
| import, importdata, method, query, vbnet |
« Matching unmatched items after import into VB6 app
|
Getting the long and laditude using MapPoint ActiveX control »
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to Import a .Net DataSet using ImportData! | Anonymous | MapPoint 2006/2009 Discussion | 3 | 10-16-2007 07:27 AM |
| ImportData method ? | mgorgone | MapPoint 2006/2009 Discussion | 2 | 06-02-2005 01:31 PM |
| c# ImportData method help needed | fletch | MapPoint 2006/2009 Discussion | 8 | 03-09-2005 09:15 AM |
| Get an error 4055 by using method ImportData | Anonymous | MapPoint 2006/2009 Discussion | 1 | 12-21-2003 12:27 PM |
| ImportData method doesn't function | Val | MapPoint 2006/2009 Discussion | 3 | 12-01-2003 09:27 AM |
All times are GMT -5. The time now is 07:11 PM.
