kardex | Sistema de Control de Inventarios

Every single control on that form is a PictureBox. That normally happens if upon loading a project, VB can't resolve the (COM) references in the project file (*.vbp). In such cases, VB throws an error message upon startup and replaces any control with a PictureBox as a placeholder.

It should have also created a file called frmKoppelBak.log in the folder where the form resides, providing more information.

And I hope you haven't saved the changes of that form (or have backups), otherwise you're stuck with th PictureBoxes. This might have happened, because you started VB6 under a normal user account on an OS > XP. Try launching the VB IDE 'As Administrator'

You are using firebase in the wrong way:

• observeSingleEvent runs asynchronously, so the order of events will be: "running in getId" -> "1:get patient name"
• updateChildValues will typically called before any of the observeSingleEvent finishes

Hence, you first write the empty(?) kardexDict to firebase, before you even get the patient or nurse name.

Also, be aware the the completion closure does not run in the main thread. Therefore, you will likely observe some unpredictable concurrency issues / race conditions. What you have to do is, to wait for all observeSingleEvent to be finished, and then write the data back.

So, an more or less 1-to-1 transfer of your idea could look like this (might not exactly compile, because I don't have your environment running):

This question is a bit unclear but I think you're asking how to create the 'kardexes' node so it looks like the structure presented in you question.

If so, here's the code that does that

You are joining to __Kardex on a BillingID of 0.

0 Does not equal 89 or 90

Your echo should produce a valid syntax, which it currently doesn't: you will need "s

This should work: echo "ondblclick=\"kardex(codigo=$codigo AND comprada<>0);\"";

Alternatively you can use ', but you cannot interpolate with them:

echo ('ondblclick="kardex(codigo=' . $codigo . ' AND comprada<>0);"');

Tip: It would have been helpful if you had included expected results in your question.

This Common Table Expression (CTE) should get you started:

Simply do