Hi I have 2 tables that have 2 columns,Name and Qty. T1 Peter,10 Paul,20 T2 Peter,15 John,10 How do I formulate the query in PSQL2000i to get this result set: ...
Natasha, Also remember to check the setting "Create File Version" under Compatibility on the Server Engine in PCC. This setting will tell you what Version of...
Hello all. V8.3, Runtime. In runtime it is possible to change the logo file, AKA Splash screen. Is there any way to control how long it is displayed ? Because...
Hi Pavel, Try this for size: SELECT Name, SUM (Amount) AS "Amount" FROM ( SELECT t1.Name, t1.Amount FROM test1 t1 UNION ALL SELECT t2.Name, t2.Amount FROM ...
Hello Sherman, Thank you for your quick response. Unfortunately this wasn't the solution to my problem. I still get the error message. Is it possible that the...
Hola, Trabajo con Magic 8 sp3, y alingresar al aplicativo me da el siguiente error: No Mayor Revision in archive files. Por favor help me... no puedo abrirlo...
Thank you I have reinstalled Magic with default IIS webserver and deinstalled Apache Iexplorer still download mgrqispi.dll instead of open the program I have...
That (the change in the value of the virtual) is the cause of the problem. What mode is the tab's task in? (query? modify?) What is your setting for "allow...
... In Magic, Settings, Environment on the Preferences tab, change line 9 "Display Copyright Messages" = Yes, or specify /CopyrightMessages=Y on the command ...
Is this also supposed to work in 9.4? I can't seem to get it to work. GP ... From: magicu-l@yahoogroups.com [mailto:magicu-l@yahoogroups.com] On Behalf Of...
Hi all, I am new to SQL, and I have a SQL file with sales data by Date, and would like to use SQL for different types of totals, Example Total By Style, Or...
I need to be able to do a sort of Mail Merge in 9.4 I want to create a catalogue page of our items - there needs to be 2 columns of items along with an image...
Does anyone have experience interfacing CC pmts with verisign ? I would be willing to purchase an off the shelf magic module, if one was available. Feel free...
I import into Magic captured transactions from the Verisign site. Using macro express, I have a routine that generates a daily activity report in ascii text...
Gary, You can use HTML and Cascading Stylesheets (CSS) for this if you are sure that most of your clients are using HTML e-mail. Most modern day mail clients...
Thanks Steve. I guess if there is no setting for "SPLASH_DISPLAY_DELAY" or something of the sorts, I will have to do it from within the application. Thanks. ...
Hi Arch, Thanks for the advice - are you using the API? If so, is it easy to integrate? Thanks ... From: Arch Lineberger [mailto:Arch.Lineberger@...] ...
Magic 9.4 sp4 with MS-SQL 2000. I'd like to know what other folk do in their applications when faced with tasks that take a little while to load their initial...
Mat, I guess that the screen is the best way to go, BUT... I cannot believe that you can _actually_ get better performance doing a Join of two Views in Magic...
Sorry I should have pointed out that the two views we are joining are separate for design reasons rather than performance. What I meant to say was that we've...
The execution of ABBYY is not difficult. Once configured, operation is simple. The trick is before and after the OCR. ABBYY will even enable you to build a...
Hello group, Magic 8.3 on Oracle (latest service packs). At random time intervals we get the error form Oracle: Ora 01722. At last we have been able to...
Steven, I'm seeing that the time on the web page is different from what you have below--I think. If that's true, I assume the web page is correct, yes? Thanks,...
Does anyone know of a way to dump the User ID list (USR_STD.ENG) to a TXT or other document type file? It's not an option on the EXPORT or EXPORT DOCUMENT...
Hi all, 8.3 sp11, Mssql 2000 Financial System I am having some trouble in some instances which I am still perplexed and unable to reproduce. "Cannot Modify...
The company just changed SMTP mail servers to PostFix on Linux and now my SMTP mail routine stopped working. It's been in production for 1.5 years with no...
I need to update Mysql password field It seems a normal magic update does not work the password needs to be encrypted This works in mysql How can I pass a SQL...
