Posts by user3771516 • 433 points
17 posts
-
0
votes0
answers34
viewsQ: MYSQL - Largest date and number of days of the current date
I have a table where reports of calls are stored. Each report may have one or more work dates. The main fields would be: nr_relatório, dt_trabalho I need to list only those reports whose working…
mysqlasked user3771516 433 -
0
votes0
answers875
viewsQ: XML Delphi - Mismatch in datapacket
I am evaluating a system made in Delphi 6, which basically uses a Tclientdataset to open xml files. This system already works for a long time and is Ok, only one xml file is indicating the error of…
-
1
votes2
answers232
viewsQ: Mysql Query - Two tables and date range
I have two tables, one for the technicians' register and one for the tasks. It’s a 1->N relation. Table 1 (TECNICO): cd_tecnico | nome Table 2 (TASK) cd_tarefa | cd_tecnico | dt_inicio | dt_fim I…
mysqlasked user3771516 433 -
1
votes1
answer23
viewsQ: Windows 7 server with Mysql 4.1
Someone would know how to tell me the limitations regarding the performance and maximum number of users to be using a Windows 7 server with MYSQL 4.1? Does it support a system used by about 50…
-
6
votes2
answers355
viewsQ: Update dlls in client
I have a software that communicates with a Mysql 4.1.14 database. I installed a new server for Mysql 5.6 tests, but when I communicate with the new database, the message appears stating that the…
-
0
votes0
answers134
viewsQ: Android games created on Cocoon js do not run on Bluestacks
I’m running some tests on Construct 2 and Cocoon Js. The . apk generated by Cocoon Js runs normally on some phones I tested, but none of them works on Bluestacks. He starts loading the game, the…
-
2
votes0
answers593
viewsQ: Delphi 6 connection error - Mysql 4.1 - libmysql.dll - Windows 8
Hello. Many should already have seen similar posts about this doubt, but I’ve done all the suggested actions, and it does not wheel. I need to connect Delphi6 in Mysql 4.1 (I cannot use other…
-
8
votes2
answers2097
viewsQ: Mysql connection failed via VBA
I am trying to connect to a Mysql database via Excel VBA, but returns an error stating catastrophic failure. I made a test by putting the wrong password, or the name of the wrong database, and it…
-
1
votes1
answer899
viewsQ: Implementation n for n relationship in Delphi
It may be something simple for most, but I would like to know how to implement in practice a n-to-n relationship between Mysql tables using Delphi. I created the diagram of my BD in Mysql Workbench,…
-
1
votes3
answers1277
viewsA: Reading in Delphi XML generated in Excel
I was able to make Delphi read the xml generated by Excel correctly: vXMLDoc := TXMLDocument.Create(self); vXMLDoc.LoadFromFile('Exemplo.xml'); J := vXMLDoc.DocumentElement.ChildNodes.Count;…
-
1
votes1
answer1135
viewsA: Create XML with Excel, date field formatting problem
I found the solution, only one question left to solve, where the date is coming out in English pattern and with "-" instead of "/" yyaa-mm-dd, if someone knows how to manipulate this in Delphi,…
-
1
votes1
answer1135
viewsQ: Create XML with Excel, date field formatting problem
I have an Excel spreadsheet, generated by SAP with a date field. I need to convert this spreadsheet to XML. I do the XML mapping by Excel, but I cannot make it export the date field as a date,…
-
4
votes3
answers1277
viewsQ: Reading in Delphi XML generated in Excel
I am generating an XML by Excel itself (file type XML Sheet 2003). The generated file has the following XML data standard: <Row> <Cell><Data…
-
1
votes1
answer611
viewsQ: PHP does not recognize Json code
I installed php + apache via Xampp. PHP is working, but it doesn’t recognize Json, anyone knows if they need to enable anything in php.ini? Returns the error: Notice: Undefined index: jsoncallback…
-
2
votes1
answer861
viewsQ: Pass values to PHP file with JSON
I have the code below that runs on any PC and asks for information for a PHP file on a remote server. How do I pass a parameter to this PHP using my JSON code? So I can send a data and have a…
-
1
votes3
answers1520
viewsA: Remote PHP access with Ajax - Return is the code of the PHP file itself
I appreciate the help of all. I managed to make it work. Below the codes. I would just like someone to give me a light on how to pass a value to the PHP file on the server, and how to treat this…
-
2
votes3
answers1520
viewsQ: Remote PHP access with Ajax - Return is the code of the PHP file itself
I have a system as below: HTML on the client side, Javascript and PHP on the server side. The idea is to have a kind of Webservice, where an HTML page (it has to be HTML because it will run in an…