topic Re: Files qvd in a process in Español

Files qvd in a process

ecolomer — Mon, 11 Aug 2014 17:59:14 GMT

We have a table of orders with various data such as:

- Order Id

- Date Order

- Zone

- Pack

- Amount

The user selects multiple orders assigning lot numbers, when the user decides, should be stored in an intermediate file (.qvd) repeating this process several times.

When reloading the orders table, you must also load this file (.qvd) in which we already have orders assigned LOTE number, reassign a new batch orders.

LOTE number should automatically generate as a sequence number.

I think the process should be based on use qvd temporary files in which to save the batch number assigned.

Any help is welcome.

Re: Files qvd in a process

ecolomer — Mon, 18 Aug 2014 06:13:49 GMT

Any help??

Re: Files qvd in a process

jolivares — Mon, 18 Aug 2014 13:23:46 GMT

Firt of all, QV is not intended to save data, is to view data.

I suggest that you assign Lote number wihtin an application, for instance in you ERP and just read data in QV.

But any way, create a variable, a listbox and a button. Select orders in the listbox, assign Lote in the variable and make a macro for saving the QVD file.

Re: Files qvd in a process

ecolomer — Mon, 18 Aug 2014 15:11:50 GMT

Si, si ya lo se que QV es para visualizar, pero tengo que resolver un tema que pasa por una simulación que hago en QV y necesito guardar grupos de datos (Num.Pedidos) asociados un dato generado en la simulación (Lote), es por eso que utilizo QV para resolver esto,

Como realmente no es necesario que sea un QVD, voy a tratar de hacerlo con un excel o fichero de texto, da igual.

La idea de la lista y el botón ya lo tengo hecho, pero la macro no me sale ... si tienes un modelo, te lo agradeceré.

Saludos,