?
Solved

Create and send a custom/windows message from sybase to Delphi Application

Posted on 2003-02-25
3
Medium Priority
?
343 Views
Last Modified: 2010-05-18
Hi,
I was just wondering if I could create a custom/windows message inside Sybase (on firing of a trigger ,say) and access that through a Delphi Application.I am using Adaptive server anywhere 7 and Delphi 5.0 on a Windows 2000 system.But of course the messaging would have to work on all Windows operating systems.

Thanks for any help.
Pat  
0
Comment
Question by:Patranjali
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 4

Accepted Solution

by:
gletiecq earned 400 total points
ID: 8027204
Unless you want to have the Delphi app poll the database looking for a flag that says it should pop up the message, no, you can't.  A database server is not designed to interact with the user GUI directly.

However, ASA7 supports java, and with java there's always a way to work around things, as long as you can figure out what client is supposed to get the message.

If you're simply trying to get some debug output, though, use the PRINT statement in your batch.  It'll print a user message to the console.  

Example:

create procedure proc_test()
BEGIN
declare thecount int;
select count(*) into thecount from dba.mytable;

if thecount > 100 then
   PRINT 'There are ' || thecount || ' rows in mytable';
end if;
END

call proc_test;

Does this help?

Greg
0

Featured Post

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
Learn how to use the free Acronis True Image app to easily transfer data between iPhones and Android phones.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month10 days, 2 hours left to enroll

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question