Posts

Access Denied from Xp to win 7 64 bit Shared Folder

access denied and account disable when access win 7 64 bit folder from Windows XP Here The Solutions Create Standard User from win 7 64 bit and name computer has "mserver" example : user - myprog Type simple Password for user Myprog examples : 123456 Create Folder Name examples : myvfp and shared for everyone and full control access. After that DONE In windows XP type Name or Server \\mserver (your computer name) If appear windows Logon Type user : myprog and Password :123456 and you can meat folder myvfp (vfp folder) If not than your Windows XP have some Problem has say : account disable or something error access denied ..... Click Start Run .... type : control userpasswords2 goto Advanced - and Click - Manage Password Click Add Type Name of Server : mserver username : myprog password : 123456 Restart your Computer and DONE Enjoy... Send me email if you have some problem at elchan99@gmail.com Thanks for your attentions

Cross Table Update with MySQL

Using MySQL version 4.0 or higher you can update a table by joining two or more tables together; note that the examples shown in this article are not possible with MySQL 3.23 or earlier. By joining two tables together you can update one table based on fields in associated records in another table. Let's say for example you have a product table which stores information about products and a productPrice table which has pricing information and you want to update the prices based on when the product was created (in the examples below you want to discount all your older stuff to 80% of the current price). In MySQL you can do this in one of two ways. The first is do do a join using commas, like so: UPDATE product p, productPrice pp SET pp.price = pp.price * 0.8 WHERE p.productId = pp.productId AND p.dateCreated The second way is to use inner join syntax as shown below. This syntax is slightly more flexible as it means you can use left and right joins as well as inner joins, whereas t...

Alias Table Not Found

IF you call multiform adding for new record you must change the form to 2 - private data session if you don't you can meat error appear 'alias table not found'

How To Open Cash Drawer Without Coding.... (New)

Dear all Foxer today i want to sharing my file o.drawer.prn that can open drawer without any coding instantly All you have to do just put this code into your object ---------------------------------------- COPY FILE O_DRAWER.PRN TO LPT1.DOS ---------------------------------------- Enjoy.... If you need file o.drawer.prn please contact me via email at : elchan99@gmail.com Best Regard

How to Add Object button in VFP _Screen Desktop

Image
Public oHandler oHandler = Newobject ("ClickHandler") WITH _SCREEN _SCREEN.Caption='SHOW BUTTON IN VFP DESKTOP SCREEN' .ADDOBJECT("command1","commandbutton") Bindevent (.COMMAND1, "Click", oHandler, "Build") WITH .COMMAND1 .Top = 80 .Left = 10 .Height = 48 .Width = 228 .FontBold = .T. .FontSize = 12 .Caption = "SHOW BUTTON 1" .SpecialEffect = 0 .BackColor = RGB(255,88,9) .Themes = .T. .Name = "Command1" .VISIBLE=.T. ENDWITH .ADDOBJECT("command2","commandbutton") Bindevent (.COMMAND2, "Click", oHandler, "Build1") WITH .COMMAND2 .Top = 150 .Left = 10 .Height = 48 .Width = 228 .FontBold = .T. .FontSize = 12 .Caption = "SHOW BUTTON 2" .SpecialEffect = 0 .BackColor = RGB(255,88,9) .Themes = .T. .Name = "Command2" .VISIBLE=.T. ENDWITH ENDWITH *---------------------------------------- Define Class...

How to Recovery MySQL database if you only have Folder Frm, Ibdata1, ib_logfile0, ib_logfile1

Are you have trouble to open database MySQL here i will show you in 4 step : 1. First Backup your database folder make sure you have 3 file and 1 folder frm(database name) or 2 folder or have more folder frm backup all (remember) - ibdata1 - ib_logfile0 - ib_logfile1 - Folder database frm 2. see what trouble you have - Access denied for user 'root'@'localhost'(using password:YES) if you try and try reinstall mysql but security not apply answer: - delete folder mysql in folder data - reinstall mysql - copy all folder frm and 3 file ibdata1,ib_logfile0,ib_logfile1 3. you should try to open database, and if you can open your database enjoy. 4. If you still can't open your database please send me email elchansoft88@gmail.com i will help you as soon as possible

Turn on MySQL query cache to speed up query performance?

As we know, speed is always the most important element in developing a website especially for those high traffic database driven website. You can try to turn on query cache to speed up query. To speed up query, enable the MySQL query cache, before that you need to set few variables in mysql configuration file (usually is my.cnf or my.ini) - 1st, set query_cache_type to 1. (There are 3 possible settings: 0 (disable / off), 1 (enable / on) and 2 (on demand). query_cache_type = 1 - 2nd, set query_cache_size to your expected size. I’d prefer to set it at 20MB. query_cache_size = 20M If you set your query_cache_type = 2 ( on demand ), you would wan to modify your sql query to support cache. SELECT SQL_CACHE field1, field2 FROM table1 WHERE field3 = ‘yes’ To check if your mysql server already enable query cache, simply run this query:- SHOW VARIABLES LIKE ‘%query_cache%’; You will see this result:- +——————-+————————————————————————+ | Variable_name | Value | +——————-+———————————————...