Viewing 15 posts - 1 through 15 (of 17 total)
Error message and method or tool used for update would be nice to be able to help you.
When using Access be careful, if I remember correctly Access 2000 is not...
April 1, 2009 at 3:02 am
Sorry, cannot help you - we use jobs and that works fine.
January 22, 2009 at 1:18 am
No : just typing in a query window and execute only first three statements.
later execute all (commenting the exit statement or whatever it is)
and then again only first three after...
September 25, 2008 at 3:53 am
Just thinking about this: having such a 'not unique' update - how often would an update trigger fire ?? Just once or for every qualifying entry?
September 25, 2008 at 12:11 am
HanShi,
thanks for your post:
yes, I found more than one entry for a lot of values.
Oh well - I still have to learn - coming from other DBMS I did...
September 24, 2008 at 5:23 am
of course I have to add that assuming in B to all key values is only one qualifying row.
What I am trying is rewriting 10 update queries into one SELECT...
September 24, 2008 at 5:09 am
The copyDB wizard is not perfect: for my taste too many things to consider (e.g. internal IDs) for it to work.
I used backup/restore switching the level afterwards if possible depending...
August 14, 2008 at 9:27 am
It appears that you have no access to the folder or file
'F:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\EBD.MDF'.
That is the default setting, which might not work for your particular install.
are you using the...
March 18, 2008 at 4:33 am
thank you laura.
that is what I am looking for.
I am not comfortable with editing the registry manually and I do not think it is good style, but seems I have...
February 21, 2008 at 5:03 am
Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=XXX.XXX.XXX.XXX;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=myUsername;Password=myPassword;
Any help would be greatly appreciated.
Hi there,
see also
(DB2 docs are ok)
Provider: IBMDADB2 when using IBM, DB2OLEDB for MS...
February 18, 2008 at 7:07 am
for those interested in 2nd: a DB Alias can be given in the GUI by choosing a DSN Name of your choice: like DB_TEST and then selecting the database in...
February 18, 2008 at 5:06 am
Thanks,
I will keep this in mind for the future.
But I am afraid that does not help right now.
The application itself is using tools based on ODBC and since I am...
February 18, 2008 at 4:28 am
Rajiv,
since I can see Long/Lat in your table I just hope you have some kind of distance function too:
select storeID from Storemaster where
order by distance(user.position, store.long, store.lat)
if you...
February 18, 2008 at 4:11 am
Viewing 15 posts - 1 through 15 (of 17 total)