Hi Keith, Wow! that is great and is exactly what i was thinking of asking next. I sure will try that and If it works it will be perfect. thanks. Azriel. ... ...
There have been numerous conversations on this in the group. Download the archive from www.magicusergroup.com/archive and search the contents. That should give...
Hi Everyone I have one year of magic 8/edeveloper experience, My company started downsizing, i have no idea what to do. I live in Canada. How i can find...
Intranet aplication - client running on (Pocket PC 2002) IE. Event: OnKeyPress Object: Document doensn't work. How can I avoid this problemn? thx for your...
Frank, This does sound like it may be related to the new license technology. The fact that you can start working with the runtime and then it crashes later on...
Hi all, I need to migrate data and table structures from a Pervasive SQL 2000 database to Oracle. The problem is to get the definitions correct. First of all...
Hi Guys, As many of you know we're converting our application to SQL at the moment. I'm just trying to get Magic (9.4 SP3c) to script the creation of one of...
Rosie AFAIK, you can simply remove the GO and run them as a single operation. In answer to your question, however, the syntax would be: CREATE TABLE LAN ( ...
Thanks Mike, That syntax works and I prefer to specify everything about a feild in one place in this way if possible. I have also tried just removing the GO...
in SQL Query Analyzer right click on the table, choose 'Script object to a new window as create', it will give a script for the complete table. ... creation ...
Hi Guys - my second question today on SQL. With Btrieve we use temporary files (NOT Memory Files) which are unique to each user and are created and deleted as...
Rosie, Previously i had a table with an extra field computername (became clientname on citrix), so you can easily create/modify/delete those records. Now in...
you can give to a table name the prefix: '#' and it will be a temp table accessible only to the current session, or: '##' it will then be a temp table...
Thank you very much, Emanuel, just one thing I didn't understend, you told me to "open your IE6 window and in the url paste the InternetDispatcherPath you...
Steve, Yes, i have tested it. It works from 9.4sp3 and above with a network licence. In your license file it needs to state P=N Possible values are: N=network ...
This sounds like what I had seen talked about on the group. Do you just put the # in front of the table name in Magic? Sounds good but my guess it this is for...
Rosie You could continue to use the same method - provided 'Check Existence' is set in the table's SQL properties Magic will issue the SQL to create it ...
Magic Software invites you to join us this coming Tuesday (August 3rd, 2004) at 12:00 PM Eastern (16:00 GMT) for a FREE live Webinar: XML and eDeveloper PLEASE...
Frank, I have written a document on 'ABNORMAL TERMINATION: Maximum aantal gebruikers is bereikt' for internal use in our company, it is in dutch. I send you a...
Jim, We have run into this error too. Looking with Dependencywalker (www. Dependencywalker.com) we found that for mgrqgnrc94.dll, wsnmp32.dll was missing on...
... Hello, I prefer to use memory files when I can, the performance (especially if the memory tables are pre-open) are far much better than using a database...
Rosie, be careful using #temp tables. If Magic opens a second connection to the database, it will not be able to see the #temp table opened by a previous...
... I didn't think at it, but there are functions in Magic 9.4 that does exactly that : MTblSet(BLOB, table entry, DB table name, mode) MTblGet(table entry, DB...
Sherm, i guess you mean MTblGet/Set-functions from 9.4. Have not used it in applications yet but if it is data which is not "temporary" (and getting it back...
Thanks to all those who have helped with my first two SQL questions today. We're pressing on with the SQL work on our CTL but keep hitting small obstacles....
Dominique, You are right - they are not really temporary files when I think about it but rather user specific files. Prefixing the user name will work for what...
