Questions tagged [external-data-source]
51 questions
0
votes
1 answer
Simple way of adding task numbers to text file
Could someone please show me a simple way of adding task numbers to my output text file. All I need is a simple way for every time a new task is added,the code should loop and add a new number to the description every time a new task is created. I…
user12739323
0
votes
1 answer
looping through task numbers
Could someone help with my current code. I would like to add task numbers to my tasks that get saved in my output text document. I would need to loop it so each task will be assigned the next task number. If possible I would like to be able to call…
user12739323
0
votes
1 answer
Adding task numbers
Could anyone help me adding task numbers to my current code. I've written code for users to add tasks for different users but now I need to add task numbers to my task output text. The current text is displaying as shown:
User assigned to task:
…
user12739323
0
votes
1 answer
How to correctly work with external text files
Could someone please help with the correct way or there opinion on this. I have written code which is below that is supposed to take input from a text file arrange one line in order and state which is the minimum number then the same on the next…
user12739323
0
votes
2 answers
How to sort numbers from text file after splitting
Could someone please help me with sorting numbers from a text file once split. I have the following text file which i need to sort the numbers from low to high. No matter the sequence or number values I need to sort them from low to high.
So far I…
user12739323
0
votes
2 answers
How to sort numbers and write to new text file
could anyone please help me with the following problem. I have a task where I need to sort numbers from a txt file from lowest to highest value. No matter the combination of the numbers or length of text it needs to sort the numbers from lowest to…
user12739323
0
votes
1 answer
How to fix while loop problem reading from txt file
Could someone lend some advice on the current problem I am having. I am writing a program to assign tasks to specific users. All the users are stored on an external txt file. What Id like to do is even though I am logged into the program as one user…
user12739323
0
votes
1 answer
Filter pivot table (connected to an external source) with range of random items
I have a list of random items that I want to filter in an Excel pivot table. The pivot table is connected to an external data source. Is there any way I can filter my entire list in the pivot table without adding one item at a time to the…
erikperik
- 23
- 4
0
votes
0 answers
Can't create External Data Source on SQL Server 2016
I have SQL Server 2016 and I'm trying to create an external data source to another database on the same server. The documentation says that it applies to SQL Server 2016 but the following command fails with error
Incorrect syntax near…
PedroC88
- 3,708
- 7
- 43
- 77
0
votes
1 answer
How To display External SQLite Database data through Recyclerview in android App?
Last few days, i have learned how to create SQLite Database and display it via RecyclerView by using SQLiteOpenHelper. in . And yes , by the power of google and Stack-overflow and i have learned it very well. However, i am having some trouble to…
Rahat
- 90
- 8
0
votes
0 answers
Trouble referencing another SQL Server instance from a stored procedure (SQL Server 2016)
I have a view in my local db that references tables in another instance of SS (same physical server). It works perfectly. However, when I copy and paste the SQL from the view to a stored procedure, the table objects are not recognized. For e.g.,…
BCanavan
- 19
- 3
0
votes
1 answer
Use VBA Code to Update External Datasource Links
I am looking to use VBA to update links for an external input file. I am a developer and the path for the linked input file I use will not be the same as the end user will need once it is placed in a production folder.
Is there a way to update the…
0
votes
1 answer
Excel Web Data Source
I am trying to populate an Excel Workbook with data from a web source using their API. When I connect to the datasource, the advanced query editor appears and I am able to browse the data, it behaves sort of like an Access Database Application. When…
Steven Nel
- 69
- 1
- 14
0
votes
1 answer
Android Studio List View
I would like to set up my code where when I click a line in my list view it returns text from a text file (from notepad or Access). Is this possible or will it need to be a different format.
This is what code I have so far, I believe it should be…
Francster
- 3
- 4
0
votes
1 answer
How to perform cross-server queries from Azure Cloud Database to On Premise Server Database
Goal
To create a query from an Azure server SQL Database to an on premise server server database.
This query used to be made using linked server objects from two on premise servers with their respective databases.
I have already successfully done…
Alex
- 4,821
- 16
- 65
- 106