OK, sudah bisa mas. Saya coba script mas Sugi, jalan.
ternyata variable str_qry dibawah ini tadinya saya bertipe integer :(
Pertanyaan saya berikutnya:
statement suspend dalam SP saya dibawah ini masih diperlukan atau tidak soalnya dari
perintah select tsb hanya menghasilkan
satu record.
CREATE PROCEDURE COMPARE_TABLE_UPDATED (
TABLE_NAME VARCHAR(40) CHARACTER SET NONE,
STR_WHERE VARCHAR(100) CHARACTER SET NONE,
LASTUPDATED DATE)
RETURNS (
RETVAL INTEGER)
AS
DECLARE VARIABLE STR_QRY VARCHAR(200);
DECLARE VARIABLE SERVERLASTUPDATED DATE;
begin
str_qry = 'select lastupdated from ' || table_name;
str_qry = str_qry || ' where ' || str_where;
for execute statement str_qry
into :serverlastupdated do begin
if (lastupdated < serverlastupdated) then
retval = -1;
else if (lastupdated = serverlastupdated) then
retval = 0;
else retval = 1;
retval = 100;
suspend;
end
end
'Parse error' ini pesan di IBExpert Personal Edition. Padahal menurut featurenya sudah
support FB 1.5.
Thank mas Sugi,
Lud
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Rent DVDs from home.
Over 14,500 titles. Free Shipping
& No Late Fees. Try Netflix for FREE!
http://us.click.yahoo.com/ybSovB/hP.FAA/3jkFAA/i7folB/TM
---------------------------------------------------------------------~->
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
