MapPoint Forums

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 ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read



Click here to register

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-20-2004
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
import query with importdata method in VB.net

Hi,

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 01-20-2004
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 2,378
Blog Entries: 1
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
__________________
~ Now taking orders for MapPoint 2009 ~
~
~ Upgrade to MapForums Plus membership ~
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 01-20-2004
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4 (permalink)  
Old 01-20-2004
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 2,378
Blog Entries: 1
The dummy table would be one of the tables in your query and linked to your main table.

Eric
__________________
~ Now taking orders for MapPoint 2009 ~
~
~ Upgrade to MapForums Plus membership ~
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
import, importdata, method, query, vbnet


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

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.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map

Cheapest Ski Holidays
Trying to book the cheapest ski holidays around? Holiday Hypermarket lets you search for cheap ski holidays from the top travel agents.

Travel Agency
We are a Queen's Award winning travel agency here to help with your travel plans.

Holiday Italy
A Holiday in Italy can mean many different things to many different people. This diverse country has an abundance of art, wine, food and stunning beaches. Book online today.

Bahamas Holidays
Bahamas Holidays offer pure blue skies, soft white beaches and the holiday of a lifetime. Visit us for a great deal to the Bahamas.

Portugal
As well as providing some great weather Portugal has much to offer culturally. There are numerous museums, monuments and places of historical interest to explore. Despite the rich history there is a buzzing nightlife and great shopping too.

Holiday Comparison
We can help you with holiday comparison when you check out the options at Travel.co.uk

Holidays in Cyprus
Visit the tombs of the island kings! Visit On The Beach for information on holidays in Cyprus.


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 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52