FOROS PROFESIONALES
WINDEV
,
WEBDEV
y
WINDEV Mobile
Inicio
|
Mensajes recientes
|
Conéctese...
|
Desconectar
|
Español
Inicio
→
WINDEV 2024
→
HReadSeekFirst on two parameters
HReadSeekFirst on two parameters
Iniciado por Christine schokkaert, 27,dic. 2004 17:19 - 2 respuestas
Conéctese…
Christine schokkaert
#1
Publicado el 27,diciembre 2004 - 17:19
I want to write in code a select statement
select * from tzipcodes where zcZipcode=Combo_TZipcodes and zcCountryCode=Combo_CountryCode
I want to use this HReadSeekFirst
But this is for only one key...
HReadSeekFirst(TZipCodes,zcZipCode,Combo_TZipCodes)
How can i do this for where zcZipcode=Combo_TZipcodes and zcCountryCode=Combo_CountryCode
I want to do this in code so not with the Query builder and save the query.
Informar
0
0
Stefan Haeck
#2
Publicado el 27,diciembre 2004 - 17:31
Hello,
2 options:
1st:
HExecuteSQLQuery("Foo","Delete from tzipcodes where zcZipcode= '" + Combo_TZipcodes + "' and zccountrycode = '" + combo_TCountrycode + "'")
2nd:
Create a composite key in your analysis in TZipcodes on zcZipcode and zccountrycode.
Then you can do a hreadseekfirst (in combination with hbuildkey) to search on that combined key.
Greetings
I want to write in code a select statement
select * from tzipcodes where zcZipcode=Combo_TZipcodes and zcCountryCode=Combo_CountryCode
I want to use this HReadSeekFirst
But this is for only one key...
HReadSeekFirst(TZipCodes,zcZipCode,Combo_TZipCodes)
How can i do this for where zcZipcode=Combo_TZipcodes and zcCountryCode=Combo_CountryCode
I want to do this in code so not with the Query builder and save the query.
Webstek:
Informar
0
0
Piet van Zanten
#3
Publicado el 30,diciembre 2004 - 13:28
Hi Christine,
You can use:
Hfilter(TZipCodes,zcZipCode,Combo_TZipCodes,Combo_TZipCodes,"zcCountryCode='"+Combo_CountryCode+"'"))
HreadFirst(TZipCodes,zcZipCode)
if hout(TZipCodes) then
//no match found
else
//match found
//process all
while not hout(TZipCodes)
//do your thing
hreadnext(TZipCodes,zcZipCode)
end
end
//don't forget to deactivate
hdeactivatefilter(TZipCodes)
best regards,
Piet
Informar
0
0
→ Volver a WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (versiones precedentes)
Français
English
Español
Portuguesa
Fermer cette fenêtre
Búsqueda Tipo
Sólo temas
Todos los mensajes
Periodo Buscar
Cualquier fecha
Última hora
Última 24 horas
Última semana
Último mes
Último año
Cancelar
Vista previa del mensaje
Añadiendo una imagen
Importar una imagen desde una URL
Enviar una imagen desde un archivo de su disco
Arrastrar un archivo o click en "Examinar..."
o
Cancelar
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Texto