Marc, The following query returns index names and numbers for a table: select Xe$Offset as Index_No , Xe$Name as Index_Name from X$File inner join X$Field on Xf$Id = Xe$File where Xf$Name =

Felix, Not sure you will get the parent task to close as you wish. For your csv, make sure the file path and name is enclosed in " " (double quotes) otherwise windows will interpret each space as an

Marc, I cannot speak for Pervasive, but with every other SQL DBMS that I have used, the optimizer will do a much better job of selecting the best index for a query than any developer. My

Hi, In Pervasive SQL V11 We are looking to force an index in a query that is having performance issue with this command "SELECT * "FROM TABLE" WITH(INDEX(hint_of_index));". We're trying to list all

Hi Magicians. A quick V8 questions (better late than never!).. What do the following parameters in a V8 MAGIC.INI control: MDIClientImageFile= MDIClientImageStyle= MDIleft = 2 MDItop = 12 MDIright =

Hey all, new here to the forum and somewhat to Magic. I've been working with magic for a couple months now and still trying to grasp and few things here and there. Currently need a bit of guidance on

Has anyone experienced trouble sending emails via outlook since the July 5 security update? We are using the OfficeCom.Outlook-MAPI Quick send Mail program and a few clients have called in

Since you are new to magic, make sure to explore how to use CndRange() instead of if() statements in your ranges when at all possible. Wes

dont be scared of mobile - once u have it setup - your building it like like the other magic RIA programs - the initial config is a bit of a challenge but after that its quick and easy

this part is very powerfull

Hi there, For magic it is not enough to set the alpha to multiline if the result would not fit in the form (as drawn); look up the form property 'Expand Form' in the help file; if you set 'Expand

I am not sure what went wrong guys. It's a 70 character alpha field and in the print details it is in Multi-edit. Program prints to PDF flawlessly except that this field won't wrap and I am losing a

Lucky you. I just gotten my formal training less than 2 weeks ago. I have to rely mostly on books, youtube and this group to bridge some gaps. Old discussions are really helpful. It's hard doing it

Man im glad these days are gone for me

I think my favorite poison would be com/activex and then windows api. The api would probably be more consistent across the systems this needs to run on though.

ONE way would be to add a new virtual variable to the very bottom of the Data pane. Make this a Logical variable, give it a Range From and Range To expression of 'TRUE'LOG and give it an Init

Thanks Tim. It solved it. First time to use this part of magic.

… and if not SQL Create a virtual Field of type logical Init the value to an expression of fieldname = “ “ or isnull(fieldname) and set the range min and max values to False. Make sure

Under CTRL+R(Im assuming your using some type of sql) in the sql where DB Sql put (fieldname >'' and fieldname not null) so the concise sql. Or the better way is zoom and pick the field name in

Need help again guys. I know this is probably simple to alot of you but I been searching for a couple of hours. I want my dataview to display records only when a specific field is not empty or not