Search results for query: *

Thank you to all friends. First, I will read the help page of friends and after applying the suggestions, I will share the result. Again, I thank all Fox friends in particular Chris and Mike. I'm sorry for the delay in replying

Hello expert friends ; My application is running very well on all system , but in one system with windows 10 os , all preview and print is 150% zoomed. It is clear that the problem is in this case. But all the outputs of other software such as Office can be seen normally. I deleted and...

Hi again . Do you suggest I create a separate dbc for each year and each point to a specific database? In this case, I have to recreate the remote views. What do you think about the least change in the program? That is, for example, for 5 fiscal years, we should have 5 similar DBCs, and only...

Hi Chris, I enjoyed your thorough explanation and others. Maybe I should have provided more detailed explanations from the beginning. Of course, I myself am a software engineer and this program belongs to me It's actually been a short time since I migrated the database to sql and it's still in...

thank you steve and mike yes i have to has seperate equal database for any year. and i search for the best and easy way for changing database without editing application. if we can just edit the connection to change a database and do not need to change remote view Then this is my point and...

Hi to every one . In local database when i need to change database juse with this command do that.( set path to 2022 or set path to 2023 ) and then use mydbf. but now how to do that in sql. because i have a database name mydata. in new year how can make a new database 2024 that user can change...

Thank you chriss, I was insert a GUID into my sql table and make primary key on it.Now this field is full and until now every thing is okay. but still when open a remote view with 50 records and make a change on some record, my records was doubled and not working properly , 1- i have a unique...

Thank you to all friends, Now i thik understand how do edit records. First open a remote cursor and make a table buffering . then user make some edit, delete and append. after that if user need to save i must do TABLEUPDATE() and everything's updated, and if no need to save I just close...

hi Chris Yes you are right. I do it in old way because my user maybe need to save and maybe do not save his work. Do you think I must work on view and all edit on it. but if user want to cancel what i must do ? also I dont a uniqe field. can i use a field with time stamp instead ? unfortunately...

Hi to every one I want to change my local table of accounting application into SQL . I make a Database and connection in it via odbc and also make a remote view for retrieve data from sql. I can read any data from sql very fine and no problem. But when I need to update some data, every thing...

Hi to all, I read all of method and way for giving some speed to solve the search problem. My friend CHRIS , this is a software for pay and receive money from passengers to a travel agency, then send a master report to accounting system to control each Contract Number individually. Here We just...

Example of my records: record 1 paid for cn 8023298 record 2 paid for cn 2196409 - 2196410 / 2196411 record 3 paid for cn 4830021 - 1260932 record 4 paid for cn 6071198 / 4930028 89236711 and so on

In addition ,when my client use a 1GB speed ,the speed of search acceptable , but in other client that use a 100MB lan speed we have a problem.

Thank you Mike and Chris, This field DESC1 is Description about paid money for some contract, usually one contract number ,but maybe in some case two or more contract number even five contract number paid at once, and this number can be in beginning of field or even at end of field, therefore I...

Hi sir , we have a table with 250,000 record. and a field name DESC1 type character 150 in it. Now I need to search a contract number in DESC1. what is the fastest way to find answer in this table ? 1- Set filter to at(variable,'table') > 0 or set index for ... 2- Set filter to (variable $...

Hi Sir Thank you to Chris and Mike that always help people like me. and also sorry for delay in answer to this topic. I will write a sample with this two way for test as you said, but I think if I use a editbox , I have some less problem because of my form width. I will write you a result...

Hi to every one I have a field desc char (120). because of my form width , i just have 50 character width for text box. now how can set it that when user type into desc , when 50 char is fulled, when type the rest of data entry, the text box scrolled and in any time user can see end of typed...

Thank you hardianwn and sorry for delay to answer. As you said this scenario is possible. Its good news for me. In this level we need just 3 user to work with exe on server side. maybe in future we need more ! this application was written by me and i can edit it. But I don't know very good about...

Very nice my friend. this is very good description for me. So I need Further research on it and more work. I am sorry for delay to answer. Apparently i must do try and error to know about this connection between data and user. I read your text several times and I try to work via your help...

Thank you Chris Is there any way that I run Vfp application with Free table via MSSQL or I must install SQL SERVER and create table on it ? I think remote view work on server and send the result to client. Can you refer me documents about making connection in database ? then i can make remote...