Search results for query: *

Hi, Can you check the names of the fields? TotalOther or TotalOrder?? I don't know if you mispelled them just in the message Regards

Thank you for your suggestions. I'm going to try the group by option. Regards

Hello, Hope you can help me with this... It is possible to print the same report several times changing the query for that report? if so, can you give me any suggestions how to do it? _____________________________________________________ I want to create a list of employees using different...

Hello, I finally found what was the problem I changed if E <> EIdConnClosedGracefully then raise with this code: if E is EIdConnClosedGracefully then else raise Apparently it is working.. Thank you so much for your help. MA

Now is giving me the following error: E2015 operator not applicable to this operand type when if E <> EIdConnClosedGracefully then raise any suggestions? MA

I'm using the component TIdSMTP (part of the IndyClients) I try your suggestion but is giving me the following error: E2003 UNDECLARED IDENTIFIER: 'EIdConnClosedGraceFully' i have this exception in my ignore list... but is not working... Regards, Ana

Yes I'm getting the exception outside (executable) and also using delphi (debugging) I add some exceptions type to ignore in the debugger options. but still receiving the message... I don't know if I'm using the correct exception... Regards AG

Hello, sorry to reply until now.... Here is the code.. fMain.SMTP1.Disconnect; fMain.SMTP1.Connect; fMain.MailMessage.Body.Clear; fMain.MailMessage.From.Address := 'email@domain.com'; Datos.qClienteContacto.SQL.Clear; xEmailAddresses:=''; While...

Hello, I'm trying to send an email using delphi win32 but it is giving me this error: "connection closed gracefully" any suggestions how to ignore this exception?? Regards MA

Hi, Thank you for your suggestions. Apparently it requires authentication. I changed the settings of SMTP Component and it works. Thank you again. Best Regards. MA

Hello, I have a problem with Email Message Component. fMain.SMTP1.Send(fMain.MailMessage); The problem is at the moment this instrution is executed. the weird thing is that in only show a little form with an X and no message at all... If I used only emails from my domain it works fine but I...

Thank you. MA

Santa Mufasa: Thank you. It was the operator <>... Sandtek: I tried to use the instructions you gave me but appears this error after choose the option... option: C old 2: ('&option', 'C', '@c:\sql\1.sql', 'P', '@2.sql', 'Q', 'exit') new 2: ('C', 'C', '@c:\sql\1.sql', 'P', '@2.sql', 'Q'...

Thank you Sandtek. I will try your suggestion in the afternoon. I'm very new in Oracle and don't understand much... but I would like to use PL/SQL, is this possible? I don't have my code test with me right now, but what I want to do is after selecting the option from the menu (which I will...

Hello, I have a simple Menu PROMPT Customers PROMPT Orders PROMPT Production PROMPT Quit ACCEPT option PROMPT "option: " Begin /*I would like to add a condition.*/ If option = 'C' then Start sqlCustomers.sql /*which is another menu containing option for Add,Modify,delete*/ if option = 'O'...

Hello, SantaMufasa Stru.sql works great. :) thank you for sharing it. and Thank you for all your help. MA

Hello, all 1. Is there a simple way to list all the tables of a database? 2. I would like to display the complete structure of a table - I tried describe but doesn't show Primary key - Foreign key constraints... Thank you for any suggestions... MA

Yes it worked. Regards MA

Hello, I don't know what was it.. I just re-type the instruction.... Thank you for all your help.. Regars, MA

Thank you Fee. The utility is working great after I restarted the computer. I have another question I'm trying to create my tables using the Editor (I don't know if this is possible?) is giving me the following error: ( * Error at line 2: Ora-00922: missing or invalid option Here is the...