vb/mysql temporary table

[bxgirl]

Can I do this in VB6 using mySQL 4?
create temporary table within VB using conn.Execute then joining the temp table to a permanent table.

 

[HermanvLimbeek]

You could use a "Create Table" query to create the table and then a "Insert Into" to fill the permanent table. Then drop the temporary table.

 

[bxgirl]

Thank you.

create table actually creates a table but what about create temporary table...will that work?

 

[HermanvLimbeek]

Well, I never tried it but it should be possible. See

http://dev.mysql.com/doc/refman/4.1/en/temporary-table-problems.html

for more information.

 

[bxgirl]

I'll have to try it.
Thanks for the link.