Page 1 of 1
About DbSeek error (DTOS (g_fech_ini). T.) to Excel
Posted: Tue Jun 16, 2009 3:37 pm
by jparada
Hi, in testing I'm doing to generate a report in Excel error when compiling my mark on the following: DbSeek (DTOS (g_fech_ini). T.), annex image error.
Any help on why I get this error and how can I fix this.
Continuing with the same subject, as I am in the process of testing, I get errors (as mentioned), and when I close my user session or shut down my computer I get the dialog to save the file in Excel.
How can I unlock the Excel object, to avoid any memory although this is not viewing the program excel open.
Thank you
Greetings
Javier
Re: About DbSeek error (DTOS (g_fech_ini). T.) to Excel
Posted: Tue Jun 16, 2009 5:54 pm
by luisvasquezcl
Hola Javier,
el mensaje de error indica que el problema está en los argumentos que estas pasando:
1. quita el segundo parametro, .T. , dentro de la funcion dtos
2. verifica que g_fech_ini sea un valor de fecha valido. Si g_fech_ini es un campo de fecha puedes verificar con day(g_fech_ini) > 0, si la funcion devuelve 0 no es válida o está vacia en caso contrario devolverá un número de 1 a 7.
Si creas el objeto excel y te sale error antes de hacerlo visible, sólo deberás abrir el administrador de tareas (CTRL+ALT+SUPR) y eliminar la tarea a mano.
Generalmente creo un array con los datos que voy a exportar a excel, asi me aseguro que los datos ya estan validados. es un poco más lento pero más seguro.
Espero te sirva,
Saludos cordiales
Luis Vasquez
Re: About DbSeek error (DTOS (g_fech_ini). T.) to Excel
Posted: Tue Jun 16, 2009 6:49 pm
by jparada
Gracias por contestar Luis, realmente tuve un error, pues muy acostumbrado a Clipper, olvide hacer ventana.objeto.valor
Gracias
Saludos
Javier
Re: About DbSeek error (DTOS (g_fech_ini). T.) to Excel
Posted: Wed Jun 17, 2009 6:24 am
by mol
jparada wrote:Hi, in testing I'm doing to generate a report in Excel error when compiling my mark on the following: DbSeek (DTOS (g_fech_ini). T.), annex image error.
Any help on why I get this error and how can I fix this.
Continuing with the same subject, as I am in the process of testing, I get errors (as mentioned), and when I close my user session or shut down my computer I get the dialog to save the file in Excel.
How can I unlock the Excel object, to avoid any memory although this is not viewing the program excel open.
Thank you
Greetings
Javier
Anything you can do, it's to call task manager and kill Excel process.
Re: About DbSeek error (DTOS (g_fech_ini). T.) to Excel
Posted: Wed Jun 17, 2009 7:22 am
by mol
jparada wrote:Hi, in testing I'm doing to generate a report in Excel error when compiling my mark on the following: DbSeek (DTOS (g_fech_ini). T.), annex image error.
I think, it should look like that:
DbSeek(DTOS (g_fech_ini), .T.)
regards, Marek
Re: About DbSeek error (DTOS (g_fech_ini). T.) to Excel
Posted: Thu Jun 18, 2009 7:37 pm
by jparada
Thanks Marek and Luis, I could solve this problem
Thanks
Greetings
Javier