Felix Not sure how you would UNION within Magic, easiest way is to create a VIEW in SQL and then use the View as your main table. Regards Steve Greenfield ...
I agree, create a view. The (only?) other way would be to write all of your records to a temporary local file with Link Writes. Pete ... From: "Steve...
Keith, There is a handler in the component that raises the public event in the application. It is not propogated. The same componetn/event works properly...
Arch, Sincde it works in an application it should work here too. What happens if you run it on a Runtime (mgrntw)? Be sure to make a fresh mff of it. Toolkit...
I agree, Frank, it should run! I tried it with mgrntw.exe with the same result. Is there some parameter in a seperate dialog (from the Events and Handler...
Arch, I agree with Frank. Have it raise a different named event in the appplication just to make sure it's raising events properly. Worst case is that you...
Freddy, Change the following entry in the Magic.ini file. AllowTesting = N ... ====================================== Keith Canniff VP Product Development ...
Thanks Keith I found it all ready after comparing some ini files. The tip given by Frank is also a good one to prevent this kind off trouble. Regards Baert...
Hello Luke, You obtain this message when there are no records in the defined range AND the Create mode isn't allowed. In fact the "mode not allowed" error...
Thank for your suggestion, I will use View in SQL for that purpose. Hope new release of Magic will be added with those two important function I think. Group by...
hi everyone! id like to ask what went wrong with my conversion from btrieve to pervasive.sql v8 data file. i am using magic 9.4 sp3c and pervasive v8 but only...
You do not have to change anything to use pervasive.sql v8 if you continue to use the Btrieve gateway. If you want to use the SQL side of Pervasive and you use...
Magicv8.3 SP12 I wrote a base64 encoding based on some specs I found on the web, but it is terribly slow for large files. Is there a Magic related uitility...
I'm really late reading this but I wonder if it is the same BUG we have seen. In our case we are not having a problem with the user changing the printer...
Magic's default storage types are not SQL compatible. You'll need to redefine the storage types and rebuild the files as outlined in the very nice article "In...
... As someone else mentioned, if you have PVSW SQL, you still have PVSW Transactional. The SQL is just a "layer" of functionality that is added to the basic...
Hi, For the first time I have installed Magic (8.2) on a Windows Terminal Server. Everything works fine if I am logged on as Administrator, but when I logg in...
Hi All, Any advice or suggestions on how to 'undo' all the changes made on a table control. [Undo] = Record only [Cancel/F2] = Record only [Rollback] = Does...
Late to the party, but I also recognize the infamous January 4, 7908 date. I believe that you've made one of the following two mistakes: 1) In Magic's Tables...
Again I'm late replying on this one but we have been doing exactly what Sherman suggests ever since we moved to SQL. It works really well. We add a link query...
From the release notes for 9.4SP3c ... <quote> Changing the Printer in the Main Printer Dialog (QCR #301328) Changing the printer in the main printer dialog...
Angel, We had the same problem and didn't find a quicker way. We were converting from Magic 9/Btrieve to Magic 9/MSSQL and basically 3 programmers took a block...
Julie, If your transaction setting is Deferred / Before task prefix, you can evaluate Rollback ('TRUE'LOG,1) to cancel all changes made in the current session....
Hello,group, Magic 8.3 SP4 In DBMS in row 8 ODBC has ID 19 in magic.ini [MAGIC_GATEWAYS] ;MGCOMM01=mgwsock.dll MGDB00=MGBTRV.DLL ;MGDB03=mdcisam.dll ...
Nope, wrong again. In fact Rollback() does end the task. The solution then will be to run your task from a drop-through parent task. In the parent, select a...
What Magic Licence do you have? If you are using the desktop licence (MGLANTK or MGLANRT) then you can't use ODBC, you can only use Btrieve and Memory in Magic...
